Show all values in Pivot Table

[Sai_Krishna]

Hi Team,

In Pivot Table, Rows (Dimensions) will not be shown when there is no measure associated. I want to display all values of dimension even though there is no data. Kindly Suggest. Attached is the sample data file and QVF.

In above table, Srilanka, UAE and USA do not Actuals data so it is not showing up.

But customer want to see both Actuals and Forecast even though there is no data.

This is just sample data, I have around 30 different categories and 50M rows data. So, Value List or Pick Match is not right option.

Regards,

Sai Krishna.

[sunny_talwar]

May be something like this

tmpTable:
LOAD DISTINCT [Country], [Date]
Resident Data;

Left Join (tmpTable)
LOAD DISTINCT [Category]
Resident Data;

Concatenate (Data)
LOAD *
Resident tmpTable
Where not Exists(Key, [Country]&'|'&[Category]&'|'&[Date]);

DROP Table tmpTable;

DROP Field Key;

[Sai_Krishna]

Thanks Sunny for taking time to get solution.

This way the data is increasing a lot and would have impact on performance of other sheets where this logic is not required. The data may be increased from 50M to 1B.

Can this be done this way?

I have created a Inline table and used it in pivot table dimension.

Category_List:
Load * Inline [
Category_List,Category_List_Num
Actuals,1
Forecast,2
]

Measure , blow is not the correct one but checking for something like this... 
Sum({<Category = {Category_List}>}Value)