Forum Discussion
Last Month Data
Hello I have a very simple issue, Below is the data set, I always need previous month count, like in current month. I need September data. PLease help.
AnonymousThanks Nick, but how do I get on previous month sum not the running total. Like In OCT I only wnat to see Sep totals.
You don't need to have the "Total Sales" measure in the table. Removing that measure, and only having the Previous Month Sales, will show October on the row, but will have September's sales. Though that could lead to some confusion.
Another idea could be to use ParallelPeriod, which shows the grand total of the previous month, regardless if you are at a lower granularity