Forum Discussion
Sum KPI values when removing attributes from a table visual using slicer selection
Hi all,
I have the following table created using a slicer selection that allows me to add or remove columns.
The approach used is described here:
However, The Sales values are not summed up when I remove Country and leave only Region. See the result below:
As report user, I would expect to have only 1 row for each region and the total sales for that region. Is that possible?
Thank you very much in advance for your support!!
Best regards
atrigo , You still have the index column, that is unique for each row.
3 Replies
- amitchandak
Super User
atrigo , You still have the index column, that is unique for each row.
Hi atrigo
Since your index is a unique value, there is no way to achieve only one row for each area you said.
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot amitchandak and Anonymous . I will keep investigating for an alternative solution to attend the requirement to add or remove columns dynamically, with an automatic aggregation of values.
Best regards
