topic Re: Dynamic Measure For Pivot table in App Development

Dynamic Measure For Pivot table

Ron1 — Tue, 04 Jun 2019 10:32:24 GMT

I want to apply dynamic measure in Pivot table.

As an example , below is my input table. Also below input table I want to see the the data in Pivot table and output should be as below

InPut:

Business Type	SubType	Sales	Type
Digital	Cloud	100	LOU
Digital	Cloud	10	IOU
Digital	IT	100	LOU
Digital	IT	10	IOU
Digital	AI	100	LOU
Digital	AI	10	IOU
Digital	HI	100	LOU
Digital	HI	10	IOU
LifeSciences	REG	100	LOU
LifeSciences	REG	10	IOU
LifeSciences	BYU	100	LOU
LifeSciences	BYU	10	IOU
LifeSciences	CUY	100	LOU
LifeSciences	CUY	10	IOU

OutPut:

The Sales Value will be shown for type 'LOU' across Business Type in Pivot. Please see the required output in attachment

Re: Dynamic Measure For Pivot table

JordyWegman — Tue, 04 Jun 2019 10:38:47 GMT

Hi Ron,

Get the following measure:

Sum({$< Type = {'LOU'}>}Sales)

Jordy

Climber

Re: Dynamic Measure For Pivot table

Ron1 — Tue, 04 Jun 2019 10:55:12 GMT

Hi Jordy,
Please check the output attachement once. For Business Type -> Sum should be for Type(LOU)
But for Subtype in the same Pivot sum of sales will be for both (Type: LOU and IOU)
Just refer the output attachment once..

Re: Dynamic Measure For Pivot table

JordyWegman — Tue, 04 Jun 2019 11:00:16 GMT

In your example I only see type LOU and not IOU. But it's not possible to have two measures in one column. You should create two measures if you want to achieve this.

Jordy

Climber

Re: Dynamic Measure For Pivot table

Ron1 — Tue, 04 Jun 2019 11:05:54 GMT

Inside input table, you can see IOU value in 4th Column.
Business Type SubType Sales Type
Digital Cloud 100 LOU
Digital Cloud 10 IOU
Digital IT 100 LOU
Digital IT 10 IOU
Digital AI 100 LOU
Digital AI 10 IOU
Digital HI 100 LOU
Digital HI 10 IOU
LifeSciences REG 100 LOU
LifeSciences REG 10 IOU
LifeSciences BYU 100 LOU
LifeSciences BYU 10 IOU
LifeSciences CUY 100 LOU
LifeSciences CUY 10 IOU
However it is possible to generate the output using a single measured field. (THis is a bit complex but possible)(THe exact output figure is possible to generate)

Re: Dynamic Measure For Pivot table

JordyWegman — Tue, 04 Jun 2019 11:20:27 GMT

This isn't possible because you can't first include and then exclude dimensions.

Jordy
Climber