Pulling specific data from a table

wschefter — Sat, 26 Jan 2019 00:12:57 GMT

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

topic Pulling specific data from a table in App Development

Pulling specific data from a table