Threshhold problem.xlsxThresholdImage.png
Hi All,
I have attached a File that contains sales store data, per store, per store level.
What I have done is found the average sales per time interval 00:00- 23:50.
Now I need to add a Dynamic threshold line on the graph so that we can easily when stores are passing the threshold (see picture).
I have tried using a calculated item which is perfect, BUT then I cant compute the average, Calculated fields create TOO many columns.
Does anyone have a solution, either with regular Excel tools or even VBA?
***This needs to stay as a Pivot table, cannot be a "Regular graph, data must be dynamic"
Thank you,
ImokatExcel
Bookmarks