Dynamic Measure For Pivot table

[Ron1]

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

[JordyWegman]

Hi Ron,

Get the following measure:

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

Jordy

Climber 

[Ron1]

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..

[JordyWegman]

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

[Ron1]

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)

[JordyWegman]

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

Jordy
Climber