Hi All, i have a dashboard with a pivot table with 3 level. 

I have  sum of all data columns also on the dashboard. 

However, i would like to make this column sums dynamic: By default thy should show the whole data column sum, but if i select a category (a row) in the pivot, they should be filtered with the selected row and show only the sum of values of the data column which belongs to the selected category. 

 Thx