Pivot table while using multiple dimension and measure

[lionking15]

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

[sunny_talwar]

@lionking15 May be use a straight table instead of pivot table?

[lionking15]

Given you the basic scenario,So can't replace the pivot table with straight table