I have an interesting problem. I am trying to pull specific data from a dimension with multiple sets of data. I have loaded the excel spreadsheet and it loaded correctly. There are 24 months of data in this file and I am trying to compare the last two months in two separate columns. I am pulling this data into a table for review.
Column: FSE/Cust Cons
Data names: FSE Backpack and Cust Consignment
Here is the formula I am using:
Sum({<[=[Month.autoCalendar.MonthsAgo] = {1}, [FSE/Cust Cons] = {'Cust Consignment'}>}EUR)
This pulls from the previous month (2 for two months ago). For these two months the data all comes back as 0. I can go back 3 months and further and all of the data pulls. The data pulls correctly if I use 'FSE Backpack' for all 24 months.
In order to determine if the data was faulty I created a new app and loaded the data. Using the above formulas everything worked just fine.
I have no idea why it would work in one app and not the other. Any thoughts or help would be much appreciated.
Thanks.
WIll