Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

how to hide subtotal values in matrix visualisations

Hello,

is it possible to hide subtotal values from selected columns in matrix visualisation in summarized mode but show them once I expand level down?

alena2k
8 years ago
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.

4 Replies

kaushikd
Resolver II
8 years ago
It seems to be modelling issue, if you could share a sample file with small dataset I will fix that for you
- Anonymous
  Not applicable
  8 years ago
  Hi kaushikd,
  
  Here is my sample file.
  
  So i wish Origin/Destination/Date values to be displayed only at the lowest level of data.
  
  Thanks, Tomas
  - alena2k
    Resolver IV
    8 years ago
    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.

Related content