AnAppleADay
New Member
- Joined
- Jun 11, 2018
- Messages
- 9
Trying to find a workaround to show a cumulative '% percent of' (currently using 'show values as'), so running up to 100% by the end of the year, hopefully more if we exceed sales expectations.
I have uploaded an example of the information i am working with as it may help to see the data - I listed 'SALES ESTIMATE' as a week number in my pivot's data source, in order to use the estimate in my 'percent of' column, as i couldn't find another way. I'm not sure if i need to just amend a setting slightly or fully change how i am referring to my estimated sales figure.
Any help on this would be very much appreciated, i am quite new to PTs.
Thank you!
https://onedrive.live.com/embed?cid...D1DAF5E07887!205&authkey=ACqXc1plaZnW72Y&em=2
I have uploaded an example of the information i am working with as it may help to see the data - I listed 'SALES ESTIMATE' as a week number in my pivot's data source, in order to use the estimate in my 'percent of' column, as i couldn't find another way. I'm not sure if i need to just amend a setting slightly or fully change how i am referring to my estimated sales figure.
Any help on this would be very much appreciated, i am quite new to PTs.
Thank you!
https://onedrive.live.com/embed?cid...D1DAF5E07887!205&authkey=ACqXc1plaZnW72Y&em=2