How to create pivot table with required fields?

For example

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


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


Hi @Sreekar_Mulinti,

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


i want to use this pivot fields in uistudio

how can in add sum values ?


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?


thank you so much for the help bro worked fine.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.