How to create pivot table with required fields?

[Sreekar_Mulinti]

For example

i want to create pivot table with
columns: S.no,Values,
Rows: Pgroup,Bgroup,Description
Values: Sum of Qty, Sum of Rgroup.
what are steps required for this ?

[Yoichi]

Hi,

CreatePivotTable activity will help you. Can you check the following documents?

Create Pivot Table

Tutorial: Creating a Pivot Table

Regards,

[Sanjit_Pal]

Hi @Sreekar_Mulinti,

Kindly go through the below link it will help you out to generate the pivot table using linq

Regards,

[Sreekar_Mulinti]

i want to use this pivot fields in uistudio

[Sreekar_Mulinti]

how can in add sum values ?

[Yoichi]

Hi,

We can use this activity not only in StudioX but also in Studio, in the latest Excel activities package, as Modern Excel. Can you try this?

Regards,

[Sreekar_Mulinti]

thank you so much for the help bro worked fine.