topic Re: aggr(RangeSum(Above( based on 2 dimensions in a pivot table. in App Development

aggr(RangeSum(Above( based on 2 dimensions in a pivot table.

stevietm — Sat, 16 Nov 2024 03:53:17 GMT

Hi All,

I hope someone can help me. I currently want to do an aggr(RangeSum(Above( based on 2 dimensions in a pivot table.

The table have to be able to expand the period dimensions to show the breakdown per company.
Find attached an excel example.

Thanks in advance.

Note: My measures are rows and my dimensions are columns.

Re: aggr(RangeSum(Above( based on 2 dimensions in a pivot table.

sunny_talwar — Mon, 09 Dec 2019 14:07:08 GMT

May be this

Aggr( RangeSum(Above( Sum({<FinYear = {'2019','2018','2017','2016'}, ManagementMap4 = {'AUDIT FEE'}, CompanyName>} -Amount) , 0, RowNo())) , CompanyName, Period)

Re: aggr(RangeSum(Above( based on 2 dimensions in a pivot table.

stevietm — Mon, 09 Dec 2019 14:13:27 GMT

Hi,

Thanks, the numbers seems to be correct now but the non expanded period gives 0's back. Only when expanding it shows the amounts.

Thanks

Re: aggr(RangeSum(Above( based on 2 dimensions in a pivot table.

sunny_talwar — Mon, 09 Dec 2019 14:16:30 GMT

How about this

Sum(Aggr( RangeSum(Above( Sum({<FinYear = {'2019','2018','2017','2016'}, ManagementMap4 = {'AUDIT FEE'}, CompanyName>} -Amount) , 0, RowNo())) , CompanyName, Period))

Re: aggr(RangeSum(Above( based on 2 dimensions in a pivot table.

stevietm — Mon, 09 Dec 2019 14:19:30 GMT

Thanks bud its work.