One way to do this is to create a calculated field similar to the following:
Or it can be added to the grand total by creating the below calculated field:
IF FIRST()==0 THEN
Then, place this on the view. Right click on Store and select Duplicate. Then, place the Store (copy) on the level of detail shelf. Right click on the above calc and select Compute using...>Store (copy)
Hope this helps!
Thank you for the answer. That way certianly helps a lot.
Sorry, I should have mentioned my final visual goal here. I wanted to visualize % of stores that had sales >=x for each division.
So I actually had a calcuatied field that returns total # of stores. So I thought I could to make another calculatied field by division like this [# of stores sales >=x] / [total # of stores]. And I would just plug that into sheet with Year on the column and Division on row.
I don't think any calculation using window function would work with that.. should I have approached this in different way from the begging? Thank you.