Pivot Chart Issue Urgent Help Needed

[#1]

Hello,

I a requirement where I need to compare 2 rows/periods and show the amount from min(period) only when the filing indicator is different for both periods.

I cannot flatten the file in Load script because I will have multiple year of data in same. I need to show the same in Pivot chart. Please Help.

[Nicole-Smith]

Dimensions:

1. Filing Group
2. Entity
3. PERIOD
4. FILING_IND

Expression:

1. sum({<Entity={'=count(distinct FILING_IND)>1'}>}Field)

I've also attached a working example.

[#3]

Hello Nicole,

The result should only show Sum of Min Period.

[Nicole-Smith]

That's different than the result you have in Test.xlsx...

I'm not sure if you want this:

Dimensions:

1. Filing Group
2. Entity
3. PERIOD
4. FILING_IND

Expression:

1. min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)

Filing Group	Entity	PERIOD	FILING_IND	min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)
TEST	8Z	201612	1	598
		201705	0	598
	F4	201612	1	-13520000
		201705	0	-13520000

Or this:

Dimensions:

1. Filing Group
2. Entity
3. =aggr(min(PERIOD), [Filing Group], Entity)

Expression:

1. min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)

Filing Group	Entity	=aggr(min(PERIOD), [Filing Group], Entity)	min({<Entity={'=count(distinct FILING_IND)>1'}>} TOTAL <[Filing Group], Entity> Field)
TEST	8Z	201612	598
	F4	201612	-13520000

If you want something different, please provide what the output should look like.

[#5]

Hi Nicole,

I have more than one filing group and I want the sum by each filing group by Entity Id where filing ind is different in both year

[#6]

it works when i select one filing group but when i select more than one filing group it doesn't work

it starts showing entities even when the filing ind is not different in both years