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.
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.
Thanks alot Hans! You are the best!