Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Hope you all are doing well
Facing an issue while creating a pivot table
Output getting
OutPut Getting | Sum({<A={'a'}>}Amount) | Sum({<A={'b'}>}Amount) | ||
A | a | b | a | b |
30 | 0 | 0 | 50 |
Expected Output
Sum({<A={'a'}>}Amount) | Sum({<A={'b'}>}Amount) | |||
A | a | b | ||
30 | 50 |
Above given is a basic scenario i have created.
Input table
Load * Inline [
A,B,Amount
a,1,10
a,2,20
b,1,30
b,2,20];
Kindly suggest a way to get the expected pivot table. Refer attached file for more clarification
@lionking15 May be use a straight table instead of pivot table?
Given you the basic scenario,So can't replace the pivot table with straight table