Adding values if no data is available

[#1]

Hello All,

I need quick help on this. I have a sales target for sales users. If any users has joined post in the years I.e. in the month of May then the data will not be available from Jan to March. But still when I want to show user target in the pivot table then it should start from Jan rather from May.

Thanks in advance.

Regards,

IK

[pokassov]

Hello!

It depends on your model. If you have table with plans and facts then you already have data values for Jun-Apr.

If you keep plans in the different table then you can put some "zero" rows into your sale table.

Can you attach your model?

[MayilVahanan]

Hi

You can concatenate the Month, users, 0 as Sales with your fact table.

Hope it helps.