How to show it in pivot table

[#1]

HI All,

I have the following table:

load * Inline

[YearMonth, Revenue, TimeId,ShowTimeId

2015-7-1,100,400,399

2015-7-1,200,401,402

];

I want to use one pivot table to show the data as following:

Dimension: YearMonth, Custom Dimension(if the ShowTimeID< the min of the TimeId then "Case1" else Case2)

The min of the TimeId for this case is 400

Metric: sum(Revenue)

How can I do that?

Thanks.

[qlikmsg4u]

Hi Issac,

Use this in Calculated Dimension

=IF(ShowTimeId < Aggr(Min(TimeId),TimeId),'Case1','Case2')

[settu_periasamy]

Hi

PFA

[#4]

Hi,

PFA.

Hope it helps.