Forum Discussion
Matrix Subtotal Issue
I have created a matrix visualization using a table. I want to change subtotal value as below image. Also need to add separate line as additional hours and it is a calculation (Total Actual Time hours - 8). Appriciate if anyone can help me to solve this.
Matrix -
Source -
Hi deepalsoft
For this case Source no matter.Some It happen in Matrix Visual.
Try This formula Template.
First You Neeed to Create one Measure.
Measure 1=Calculate(Sum(Sales))
You Should Measure 2 paa into the Visuals.
Measure 2=IF (
HASONEFILTER ( Column Name ),Measure 1,Sumx(Values(Column Name),Measure 1))
If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.
Thanks,
Thennarasu
9 Replies
- Thennarasu_R
Responsive Resident
Hi deepalsoft
For this case Source no matter.Some It happen in Matrix Visual.
Try This formula Template.
First You Neeed to Create one Measure.
Measure 1=Calculate(Sum(Sales))
You Should Measure 2 paa into the Visuals.
Measure 2=IF (
HASONEFILTER ( Column Name ),Measure 1,Sumx(Values(Column Name),Measure 1))
If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.
Thanks,
ThennarasuSame result. anythis is wrong?
Measure 2
Measure 1
- Thennarasu_R
deepalsoft
Yes you Did some mistakeI marked in this image there you Should Use Employee Id Columns or Other Columns .Don't use the Actual Time Cost Column Both Place .
If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.
Thanks,
Thennarasu
- Thennarasu_R
Anonymous
I thought Hashone is not correct one . Why I'm Saying This one HashoneValue function accepted Cross Filter .
Hashone filter Ignore Cross Filter That a Reason for this scenarios I choose the Hashonefilter.
If i have answered your Qus Kindly Give Kudos and Accepeted a Solution.
Thanks ,
Thennarasu
