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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use hasonevalue function there.

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

    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