Forum Discussion

r_marsicovetere's avatar
r_marsicovetere
Frequent Visitor
3 years ago

Summarization issue

Dear community, this the first time that I'm raising a question, so I hope to post it correctly. I have a set of data that should be aggregated by different levels (Level 1, Level 2, Level 3). The ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi r_marsicovetere ,

 

You could put the columns in matrix, put levels in Rows field and it will aggregate at row total field.

 

Best Regards,

Jay

  • r_marsicovetere's avatar
    r_marsicovetere
    Frequent Visitor
    3 years ago

    Hello Jay,

    thanks for your feedback.

    If I got it right,your suggestion is to organize the datas like the following

     The problem that I have in doing that, is that when I create a slicer to navigate the different level, the correct values for F1 will be shown just selecting F1 in the lower level of the slicer, but this is not correct. 

     

    Also, when creating graphs, the drill down and up functions will not show correct figures because aggregating the figures in the wrong way.

    Thanks in advance for your help.

    BR