in matrix table need values only in grand total column

[Akhil_raj]

in matrix table i dont need to see Total kms(Highlighted)  coloumn in sub coloumns instead need the calucaltion in grand total coloumn only, i already have a measure to do the caluclation .

[ChiragGarg2512]

Apply a filter to the visual and uncheck the total kms option.

[Akhil_raj]

can we apply filter using measure?

[ChiragGarg2512]

The column that is used to break dates into first vehicle status and total kms. Apply that to the filter visual

[Akhil_raj]

@ChiragGarg2512 i should have been clear, Total kms is a measure not a colomn

[amitchandak]

@Akhil_raj , Refer the calculation group approch

https://www.youtube.com/watch?v=1_6S2sb1f90

[Akhil_raj]

Hello Amit,

its not about having zero in values, could you please help me with hiding subtotal coloumns and just to present grant toal for Total kms