How to see detailed Totals when you have two dimension on rows

Options

Hi,

We have a Dataview where we have two entities on rows: Region and RL, like follows:

The Total row adds all the rows, which is OK for the region but has no sense for the RLs.

Is there a way that I could have the Total region detailed by RL?

Thanks

Tagged:

Answers

  • Samson Sunny
    Options

    Hi @Jordi Vilamajo ,

    Have you considered using the Drill-down on the total to get the detailed view by RLs?

  • Björn Reuber
    Options

    Hi @Jordi Vilamajo ,

    when you use flatten view the Subtotals are not displayed. If you want to see the subtotals, please disable the flatten view.

    Regards

    Björn

  • Jordi Vilamajo
    Options

    Hi thanks both for your answer.

    I would discard the drill down because totals should be more direct and visible for the user.

    I have disabled the flatten view but I must still be missing something as I still don't see the RLs of the Totals: