Display sub category average's total as a top level in drill down chart

[Krunalbpatel]

I want to display sub-category average's total on top level of the drill down report.  And on second level I want to display average of sub category individually. How can I display this and calculate my value.  Please Help me in this.

[Habib]

One option is to use Line and Staked Column chart, Use Sub Category average as line and individual category as bar. You might need to add calculated measure for average of Sub Categories as well.

[Krunalbpatel]

But I have to display sub categories average's sum on top level of the chart. This is already I have done. But I can not display total numbers on top of the column.

[Habib]

What visualization you are using. Can you please put snapshot?

[Krunalbpatel]

Here 1 and 2 is the average of my sub category. But now I want tot display only 3 in this column bar,  means that only total will display (3). And on the second level display this sub category individually i.e 1 for category 1 and 2 for another category.

Note :-  I also want to filter report on yearly, monthly, quarterly, and weekly etc...

[Habib]

It will not be possible in this case. it will only show sub category level individual value.