Forum Discussion

deepalsoft's avatar
deepalsoft
Regular Visitor
3 years ago
Solved

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 hour...
Need Help
  • Thennarasu_R's avatar
    Thennarasu_R
    3 years ago

    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

deepalsoft's avatar
deepalsoft
Regular Visitor
3 years ago

Same result. anythis is wrong?

Measure 2

 

Measure 1

 

 

Thennarasu_R's avatar
Thennarasu_R
Icon for Responsive Resident rankResponsive Resident
3 years ago

deepalsoft 
Yes you Did some mistake 

I 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