Ii have pivot table with 3 dimensions namely dept,year,region. I want a set expression to calculate sum of sales where dept should remain static and other two dimension shold change as per selections. Pls some help me
That's not possible if you use dept as a dimension in your pivot table. The easiest fix is to remove dept as dimension from your pivot table and add a listbox with dept as field. Then simply select the dept value you're interested in in the listbox. No set analysis necessary. Or if you do not want to use a listbox you can hardcode the dept in a set analysis expression. Something like sum({<dept={'MyDept1'}>} amount).
