topic Re: Totals In Pivot Table with Measures as Rows in App Development

Totals In Pivot Table with Measures as Rows

m_perreault — Tue, 05 Jun 2018 16:22:19 GMT

Hi All I have the below Pivot Table which has measures as the rows. Is it possible to get totals for each measure?

Re: Totals In Pivot Table with Measures as Rows

sunny_talwar — Tue, 05 Jun 2018 16:35:58 GMT

So, NAV, Total Debt, Cash.... etc are values within a field? and you would like to add Total Sources and Total Uses as extra values?

Re: Totals In Pivot Table with Measures as Rows

m_perreault — Tue, 05 Jun 2018 16:42:43 GMT

Ah sorry ignore the coloring. Each row is a different measure/expression and I would like to show totals for each measure across all companies. So ideally there would be a totals column which shows the totals for each measure. i.e total nav = Company 1 NAV + Company 2 NAV + Company 3 NAV Etc

Re: Totals In Pivot Table with Measures as Rows

sunny_talwar — Tue, 05 Jun 2018 16:46:03 GMT

Oh got it... may be add a island table in the script like this

Dim:

LOAD * INLINE [

Dim

];

and then change your Company dimension to this

Pick(Dim, Company, 'Total')

Re: Totals In Pivot Table with Measures as Rows

m_perreault — Tue, 05 Jun 2018 20:03:03 GMT

Awesome thanks!

Re: Totals In Pivot Table with Measures as Rows

m_perreault — Tue, 05 Jun 2018 20:22:56 GMT

One more question. My total responds to selections made, ie if I select company 1 the total column will show the same values as just company one. Do you have an idea on how to have the total column show values for the whole data set.

Re: Totals In Pivot Table with Measures as Rows

sunny_talwar — Wed, 06 Jun 2018 00:08:10 GMT

May be try this expression

Pick(Dim,

Sum(Measure),

Sum({1} Measure))

Re: Totals In Pivot Table with Measures as Rows

Mihail_RIX — Mon, 16 Oct 2023 10:46:41 GMT

Will it be possible to make the same, but for columns?