Dimension in Pivot Chart independent on current selection

[MWiciok]

Hello,

my set-up looks like this:

DOKU_ID	WFL_STEP	USER	TSTAMP_RECEIVED	TSTAMP_SEND	ACTIVE
1	A	Tim	10.12.2013	11.12.2013	0
1	B	John	11.12.2013	13.12.2013	0
1	C	Samantha	13.12.2013	16.12.2013	0
1	C	Gina	13.12.2013	16.12.2013	0
1	D	Tony	16.12.2013		1
2	A	Samantha	12.12.2013	14.12.2013	0
2	B	John	14.12.2013		1
2	B	Tony	14.12.2013		1
3	A	Tim	15.12.2013		1
3	A	Gina	15.12.2013		1

I want a Pivot Chart with the Dimensions WFL_STEP and USER. The Functions should be TSTAMP_RECEIVED and TSTAMP_SEND. The Chart should just be visible if you select one DOKU_ID. This is possible to do for me. Now to my Problem: I want the Pivot Chart to ignore any selection on the field ACTIVE.

See attached file: I want now the Pivot Chart to show all Information to the DOKU_ID.

This might be easy to solve, but I got no solution. And ideas?

Thank you for helping me

[Anonymous · Accepted solution]

Matthias

Have you tried Set Analysis to ignore selection on ACTIVE :

     = only( { < ACTIVE=> } TSTAMP_RECEIVED  )

     = only( { < ACTIVE=> } TSTAMP_SEND  )

Best Regards,     Bill

[MWiciok]

Hi Bill,

thank you for your quick response.

No, I did not. I always tried to "manipulate" the dimension.

Matthias