Forum Discussion

anjanikumar's avatar
anjanikumar
Helper III
10 months ago
Solved

Matrix visual issue !!

In this visual Planned Need(FY) column was showing 3 times tertial wise, but i need only one time to show that , How to fix this in matrix visual ?    
Need Help
  • v-venuppu's avatar
    v-venuppu
    10 months ago

    Hi anjanikumar ,

    Can you please share the sample data along with expected output, so that it will be helpful for us to solve the issue.

    Thank you.

amitchandak's avatar
amitchandak
Super User
10 months ago

anjanikumar , You need to create a calculation group there we can control if we want to details for a measure or not 

You can check if value isisnscope 

 

code of calculation group item 
if(isinscope(Table[Cate]), blank(), [Planned Need(FY)]) 

 

The second calculation item will simply have the measure 

example : https://www.youtube.com/watch?v=Eh4wJtGjSEE

  • anjanikumar's avatar
    anjanikumar
    Helper III
    10 months ago

    when ever column sub total is enabled again some columns repeating in Total Level (Palnned Need, Need change Ratio , Need Share ratio basis Range status )which are not required , how to remove it in Totals without effecting  same columns in Tertial level ?