Pivot table- expand all dimension values

[dseelam]

Hello All,

can i get same columns as straight table in pivot even after summing records.

attached QVW 

[Arthur_Fong]

Expression should be :

sum({<cust={'b'},series={'north east'}>}units)

But your table does not have any data for cust B, series north east.

So the result will be 0 in this case.

[dseelam]

Hello Arthur,

I don't want other column with data I want to expand both a and b customer with all series regardless of null units and price