how to get total sales based on drill down dimension selection

[abc_18]

Hello Everyone,

I have a bar chart with 2 dimensions and 1 measure, as shown below:-

Here one of the dimension State is a master dimension (a drill-down dimension).ro_so->ro_do->district

My requirement is to display the total sales value as a second measure which gives the total value grouping  for each product , for which I am using tooltip as shown below.

I tried using the expression :- sum(total <product> sales), but it's not giving me total value.

and if user select any sales office, then it should further drill down to District office and total sales value grouping should be based on ro_do product wise.

Please suggest

Regards

[abc_18]

Hi Juan,

Thanks for your response. tried the above expression even with error, but same issue:-(

No total sales at RO level.

Regards

[JuanGerardo]

Then probably there is something in your data or model that has to be considered here. If you can replicate this with an example data set or app...

[abc_18]

Hi Juan,

I tried working on the sample data and it's working perfectly fine there, but not in my application.

In my app I am using two tables by linking them, don't know what can be the issue. will again look into that.

Thanks for your help

Regards