Forum Discussion
Missing Sales Month in Pivot Table for Measure Containing TOTALYTD
Dear Members, I have 2 tables: 1. Sales Transactions for 2019 (the last month is July); 2. Calendar with unique dates from 01/01/2019 until 31/12/2019. The above-mentioned tables are linked by...
Thank You very much for Your response. Highly appreciated. I wrapped up the LASTNONBLANK into EOMONTH0, and it did the trick.
amitchandak
Super User
Super UserI think first of all you remove the filter of last not blank and check if July is coming.
If so put the TotalYTS into a VAR and use if not top of IT
YTD Sales = Var _sales = TotalYTD(...) Return IF(not(isblank(_sales),_sales,blank())
Or put this into a calculate to filter blank
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.
Thank You very much for Your response. Highly appreciated. I wrapped up the LASTNONBLANK into EOMONTH0, and it did the trick.