topic Re: pivot table with two/many measures with different dimension on its own in App Development

pivot table with two/many measures with different dimension on its own

Rajashekar — Wed, 07 Jun 2023 13:06:50 GMT

HI all,

is it possible to have different dimension for each measure in pivot table where row dimension are same.

expected outcome:

Country	Sum(Sales)		Sum(Sales)		sum(Sales)
	A	B	X1	X2	m	n
India
UK
Canada

measure is same will be added multiple times but each has to expand with different dimensions.

Country	Sum(Sales)		Count(Sales)
	A	B
India
UK

two different measures, only first one need to expand but not second.

simply put joining 2 or more different pivot tables joining side by side skipping country details(same row ).

Appreciate any thoughts.

Re: pivot table with two/many measures with different dimension on its own

marcus_sommer — Thu, 08 Jun 2023 11:35:20 GMT

You couldn't get a layout like in Excel but you could show the results in a very similar look - but you will need to do some extra measures by creating an appropriate dimensional structure which means to create some main- and/or sub-categories to your dimension and/or to extend your dimension for the additionally parts like any included total/rate columns and/or as-of-table logic for overlapping calculations.

Another way might be to skip these dimensionality and applying for everything an own calculation.

I suggest to avoid such measures because it just creates efforts without much benefits because the essential information of the data could be als displayed with normal objects.

Re: pivot table with two/many measures with different dimension on its own

Rajashekar — Fri, 09 Jun 2023 12:23:35 GMT

Thank you marcus for your response.

I thought of your 2nd suggestion, creating each measure of its own but there are many values in expansion- as your said just creates efforts without much benefits.

Will try your first option of extending dimension and use as-of-table logic.

I am currently sticking to multiple pivots.

Thanks

Raja