Populate cells

[mariozubieta]

Hello,

I was wondering if some has encountered a similar problem.

Im trying to create a number of tables that show sum(number) for the current and next 3 quarters.

so for example it'll show 2017-2,2017-3,2017-4,2018-1.

The thing is there is one table for each area.

Initially i had no problems showing the numbers for the distinct areas.

The problem is when few weeks ago a new area was added. Since its new, it does not have to much information yet, and there are no numbers for 2018-1, si the table only shows 3 rows.

Ive tryed different things so itll show a 0 on 2018-1, so all tables look alike but havent find a way to do it.

Ive tryed using different things, like using isnull() on a conditional to show a 0, but it doesnt seem to work that way.

Im using a pivot table with a calculate dimension just called "Rolling qtrs" and a second dimension with all my Quarters.

Im using set analysis inside the expression to only calculate for 2017-2,2017-3,2017-4,2018-1.

Anyone have solved a similar problem?

thanks,

[Anil_Babu_Samineni]

Does you meant to say, If you select 2017-2 Quarter name you want to fetch next 3 quarters of data and do you ahve data for 2018-01 because usual all DB has only till this date data only.

Well, Let's think related FY 2017-2018 how you want to be quarters in your Data model

[mariozubieta · Accepted solution]

Not really.

I was just that the info didnt existed on the DB. Like actual IDs with the information.

I added some dummy lines to the table so it shows the 0 now.

thanks anyway