Forum Discussion
how to hide subtotal values in matrix visualisations
I have one idea which will make sense out your data and get you close. It is not ideal, but maybe you can figure out complete solution based on it.
1. Go to conditional formating for Origin/Destination/Date
2. Set foreground color using 'Format by Rules: if Count of Shipment ID (alway true for your lower level) is 1, then black otherwise white (or any color)
3. Set backgroung color using 'Format by Rules: if Count of Shipment ID is greater then 1, then white (or the same color as above)4. Go to Field formating and set white on white as color for Origin/Destination/Date, but apply it ONLY to subtotals and total
This approach will still show data for Origin/Destination/Date on higher levels if there is one and only shipment, otherwise it will do what you need.
Resolver IVI have one idea which will make sense out your data and get you close. It is not ideal, but maybe you can figure out complete solution based on it.
1. Go to conditional formating for Origin/Destination/Date
2. Set foreground color using 'Format by Rules: if Count of Shipment ID (alway true for your lower level) is 1, then black otherwise white (or any color)
3. Set backgroung color using 'Format by Rules: if Count of Shipment ID is greater then 1, then white (or the same color as above)
4. Go to Field formating and set white on white as color for Origin/Destination/Date, but apply it ONLY to subtotals and total
This approach will still show data for Origin/Destination/Date on higher levels if there is one and only shipment, otherwise it will do what you need.
Hi alena2k, thank you! That worked.
Just small thing - I used Count(Distict) because my data source contains multiple rows with the same Shipment ID.