Need help in creating custom Pivot Table

Hello,

I have 5 columns in my dataset like campaign_type , category , type_of_comm , total_ids and total_comms.
Now I want to create a pivot table such that campaign type should be in the first column, then category in the second column and type_of_comm in third column and sum of total_ids and total_comms in the values.
Now the main problem is, I want an expand option for the category column but campaign and type_of_comm should remain there.

Hi @nishchay0001,
Could you share a screenshot of your visual to help explain what you’re looking to accomplish in this case?

Thank you

Hi @nishchay0001,
It’s been awhile since we last heard from you, did you have any additional questions or were you able to find a work around for your case?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

Hi @nishchay0001,
Since we haven’t heard back, I’ll close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!