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.
I have the example attached to the original post.
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.
I clicked on 2023 (2022 would have been OK too), then selected Fields, Items & Sets > Calculated Item...
- One last question: I think I found what seems to be the issue for me. I created the formula in a calculated field. However, in the excel example which you gave me you created a calculated element. How did you do that? Because under the Pivotheader Fields, Elements and Groups I can not select the option "Elements".
- Thanks alot Hans! You are the best!