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 hours - 8).  Appriciate if anyone can help me to solve this.

 

 

Matrix - 

 Source - 

 

 

 

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

9 Replies

  • Thennarasu_R's avatar
    Thennarasu_R
    Responsive Resident
    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
        Responsive 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Use hasonevalue function there.

    • Thennarasu_R's avatar
      Thennarasu_R
      Responsive 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