Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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)