If I have 2 different aggregations in the pivot table - One parent level and a child level calculation with these in the rows, is there any way I can show both calculations in the same picot table ?
Parent_level_Conversions = sumover( conversions,[Parent level])
Child level conversions = Sumover (cpnversions [child level])
Hi @liya101,
Unfortunately Quick Sight’s pivot tables do not have that type of flexibility when it comes to aggregations. If you add a second row, the values will sort out to those rows.
You could potentially try adding both calc. fields to the value section; if you toggle on subtotal, the parent level sum may show in the subtotal section but visually, may not be ideal.
Applying various aggregations to pivot tables would be helpful so I’ll mark this as a feature request to promote visibility to the support team.
Let me know if you have any additional questions
Hi @liya101,
Following up here as it’s been awhile since we last heard from you; did you have any additional questions regarding your initial post? If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
Hi @liya101,
Since we have not heard back and I’ve already marked this as a feature request; I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you!