Forum Discussion

krrish116's avatar
krrish116
Resolver II
5 years ago
Solved

Aggregate value based on two columns in Matrix Visual

Hi amitchandak , I have to show some data in a matrix visual where in rows it contains Group , Division , Branch  In columns it contains Value , Target.   Group     Division     Branch          ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    krrish116 , Can update your final result with the numbers. Not able to get that yet 

amitchandak's avatar
amitchandak
Super User
5 years ago

krrish116 , that  you should get as subtotal ?

or add new measure

 


divide(sum(Table[Value]), sum(Table[Target]))

 

or

 

calculate(divide(sum(Table[Value]), sum(Table[Target])), filter(allselected(Table), Table[Group] =max(Table[Group])))

  • krrish116's avatar
    krrish116
    Resolver II
    5 years ago

    Hi amitchandak ,

    I want aggregate for each and every group in the place of subtotal?,

    and the value and target are mesures not columns.

    Thanks,

    Krishhh

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      krrish116 , do you want to remove the subtotal of division?  Under subtotal, you have an option for Per Row Level Switch on and remove subtotal for division and branch as per need

       

      • krrish116's avatar
        krrish116
        Resolver II
        5 years ago

        Hi amitchandak ,

        The Value and Target and Subtotal is coming only for Branch.

        The Aggregate mesures are not working on matrix visual, if i put that measure on visual then it is showing Blank.

        Please help me to sort it out .

        I need Aggregate for the bottom of each branch i.e Total Value / Total Target.

        Plese let me know, if is not possible due to limitations then i will leave this issue.

        Thanks for your support in every issue.

        Thanks,

        Krishh..