Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
can i get same columns as straight table in pivot even after summing records.
attached QVW
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.
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