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 , 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..

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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