Forum Discussion
Dynamic dimension to Column chart drill mode
Please find the updated file
https://drive.google.com/file/d/1ypP38IZqdHAHwewn2xr0C-EbT0HDvmQY/view?usp=sharingIf the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Another issue is that in this solution the numbers that I see in the top level are not correct, it shows only the sum of the first top 3 values of the lower level and I don't what the numbers to change
Let's assume that Customer A has a total sales value of 1000 USD
Devided into 4 Products:
Prod 1 = 300 USD
Prod 2 = 300 USD
Prod 3 = 300 USD
Prod 4 = 100 USD
in this soultion I will only see total sales of 900 USD in the upper Customers level which is wrong 😞
The sames goes to the next lower levels I assume
Thanks
Shlomi
Super UserPlease find the updated file
https://drive.google.com/file/d/1ypP38IZqdHAHwewn2xr0C-EbT0HDvmQY/view?usp=sharing
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun