topic Re: Pivot table while using multiple dimension and measure in App Development

Pivot table while using multiple dimension and measure

lionking15 — Sat, 16 Nov 2024 01:20:39 GMT

Hi Guys,

Hope you all are doing well

Facing an issue while creating a pivot table

Output getting

Expected Output

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 — Thu, 01 Oct 2020 16:40:50 GMT

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

lionking15 — Thu, 01 Oct 2020 16:54:28 GMT

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