topic GroupBy in Pivot Tables in Dashboards & Analytics Discussions

GroupBy in Pivot Tables

msamuels5 — Mon, 07 Nov 2022 19:08:00 GMT

Are there any plans to add the GroupBy formula to Pivot Tables. It would be handy to be able to show percentage splits by dimension and date as a trend.

Re: GroupBy in Pivot Tables

Prince — Wed, 09 Nov 2022 09:44:20 GMT

Hi @msamuels5 ,

We do support grouping by a formula in a Pivot Table. Can you please elaborate more about the use case or the desired output? And which Incorta version are you on now?

Re: GroupBy in Pivot Tables

msamuels5 — Thu, 19 Jan 2023 15:25:43 GMT

Sorry wasn't alerted to this response. I want to do a percentage share using the GroupBy, but show it over a period of time. That is the need for the pivot table to show multiple dimensions on the rows and time series on the columns. My current version is 5.0.4