I am working on Excel Report (Excel 2013 pivot table). I have a field called [Day of the month] which I dragged onto Columns in the Pivot Layout.
At the end of the column I added a new field USD (USD=Total item Qty/No.of Days).
My problem is when I select 2 or 3 days in the filter[day of the month], the column width is reducing but the formula field USD is not reducing.
Here is what I have so far :
Day 1...........................2
Qty USD Qty USD Total USD
10 50 20 30 50+30/count of days i.e 2
so i should get 40...
Here date field is filtered..If i select 10 days then column width increases.But my formula field i.e Total USD is not increasing accordingly
How can I write dynamic formula so that my USD field increase /decrease according to filter selection?
I want to make clear my previous question
Day 1...........................2
Qty USD Qty USD Total USD
10 50 20 30 50+30/count of days i.e 2
so i should get 40...
Here date field is filtered..If i select 10 days then column width increases.But my formula field i.e Total USD is not increasing accordingly