Your workbook doesn't embed data, I can't open it.
1 of 1 people found this helpful
thanks for your workbook.
your 1st question is easy to fix, you need create a calculation field for filter as shown below
Drag it to filter and select true, below is the result.
I am not quite understand your 2nd question. seems you already achieved what you want, could you please explain more about that?
I attached the workbook for 1st question.
ZZ - thank you so much for your reply. It worked (so far).
What I am getting at with my 2nd question is that my last two columns don't calculate accurate numbers. Column 1 (Airport Pax Total) shows Amount of Passengers for that month & year. Column 2 shows % Change in passengers YoY (change vs. same month previous year). Both of these are showing correctly.
However, the remaining two columns (Column 3 - Total passengers YTD and Column 4 - % Change in total passengers YTD vs. previous year) are simply copying the numbers from the first two columns, rather than calculating my YTD indicators. From the Month's drop down menu, I select a single month up to which I would like YTD indicators to be calculated, yet, it's not working for me that way. I manually have to filter out for all those months that I want to be included in the YTD calculations.
At the end of the day, as I mentioned in my initial post, I want to have a dashboard with all four indicators shown in graphs, but also show "big fat numbers" for the latest month as a quick snapshot for the consumer. Similar to how this guys describes it in this video: https://www.youtube.com/watch?v=YSGTk3_N4Us
Does it make sense?