Can someone please help me with this?
Did you still need help with this Matylda? It looks like the packaged workbook already contains the desired values.
Good morning Tracy!
Thanks for getting back to me. I have not solved this problem yet, the workbook contains values where the time frames do not adjust, however I need a dynamic solution.
I am really stack I don’t know further, I went through the posts on “yoy change, ytd comparisons”, however they aim slightly different goals. I thought I send you my Dashboard so you can see where I want to implement the” yoy change in % to YTD/previous year” (KPI workbook).
I have further questions and I would very much appreciate your feedback
- Global filter : “Spendings per month” should not react on global filter, since I want to see the trend over all years. How do I do that?
- Dynamic title: Please see my solution with Min and Max (Date), however is there a better way to solve it so I can add plain text there? Such e.g. “Time frame: Jan 2012-Sep 2012”
-Share of advertising: I would lie to calculate a share and place it in the KPI workbook as just one number: Sum(Euro[for selected brand])/Sum (Euro [all brands]).
Many thanks, Matylda