Forum Discussion
Solved
Pivot Table Turnover 23-22
Hello together, I have the following problem. I have sales figures of my company displayed in a pivot table, based on the year. Unfortunately, I only have one field in which the turnover is displaye...
This worked for me: ='2023'-'2022'
I have attached the workbook, but you'll want to create the formula yourself, since the labels were changed to English in my version.
Note that I turned off the grand total for rows, because Excel would include the Differenz value in the grand total.
HansVogelaar Hi and thanks for the quick reply. Unfortunatly Excel can't address the Year field. I get the following error:
- Good morning Hans,
no it doesn't work. Either I get the error that it can't resolve the Year or if I put it in "" I get a Value Error because it is seen as Text. I don't get why Excel has a SUM function but not a difference function...Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I have the example attached to the original post.