In OAC DV, Do we have an option to show condition based Grand totals in Pivot table?

Question

Our requirement is to enable dimension attribute value specific grand totals in Pivot table. For example: When we enable grand total on pivot table visualization it shows grand totals for all values of columns. We wanted to enable totals only for specific values. Is there a way to achieve this in DV?

Rajakumar Burra · Answer

With March updates, conditional formatting limitations are fixed. I think we have all required options including your query now.

Gianni Ceresa · Answer

Selection steps have been added to DV in the last year (can't remember which OAC release it was).

@User_A63N1 , the automated grand totals (or sub-totals) in tables and pivots have no options, they automatically aggregate all the measures at the level they are enabled.

For what you ask, you should consider a calculation that let you pick the columns you want, and then you add it to the visualization and try to make it look like a grand total by changing the style of that column.

Of course the selection steps mentioned above could also be an option, but it depends fully on your exact case.

https://youtu.be/J2jSMZNFyJk?si=FOue0g2a_dYVj0Vk

Daniel Ryan · Answer

Hi @User_A63N1  I don't think it is currently possible to do this in DV. I have tried looking at options for conditional formatting for this in case it is definable by a rule however I can only see a way to do this for the main data columns not totals.

@Brendan T there is no selection steps pane for DV that I am aware of. Is there something I am missing?