1st, sorry for my english, i m french.
I want to know if it s possible to use roles (Region 1 only data R1, Region 2 only data R2 ...) and put subtotal with sum of all Region data. It s reference and important to see this data for them.
I put screen shoot for explain my question.
Go to Solution.
I haven't tried this case but it's so lucky to have new topic from sqlbi.com about this scenario:
Hope that topic could fit your need.
View solution in original post
Ty for your link.
I duplicate my table with data and remove columns i dont need. I use this one for my aggregate values.
It seems same solution but i want to know if i dont ignore existing function.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!