I have created a Pivot Table for sales comparison purposes, I summarize Units and $ and group them together by Budget, Last Year and Actual.
I can see the numbers but if I want to make a comparison and I choose % OF, the values automatically are replaced by the %.
Is it possible to create a pivot table that can have values and the %OF, comparing Units and $ actual vs. Last Year and budget in the same table?
I have done it manually in the past but it is too much work, that is the reason I prefer to use a Pivot Table (the number of records I have are more than 30,000)
Thanks
I can see the numbers but if I want to make a comparison and I choose % OF, the values automatically are replaced by the %.
Is it possible to create a pivot table that can have values and the %OF, comparing Units and $ actual vs. Last Year and budget in the same table?
I have done it manually in the past but it is too much work, that is the reason I prefer to use a Pivot Table (the number of records I have are more than 30,000)
Thanks