Hold the data in Table based on previous selections also

[jagannalla]

Hi,

- I've a barchart with dimension i.e group and also with the one slider & straight table.

- When i change the slider the data is reflecting in bar chart and table based on group selection.

- Now, i'll select the another group selection and i'll change the slider then i should get current selection group data along with previous selection of group data in the straight table .

How can i do this?

[#2]

I don't understand exactly what you are trying to accomplish. Can you give more info about the table and the slider? What values does the slider hold? How do these relate to your chart and what is your group?

You would probably need a way to store the contents of the slider and/or the selected group in a variable. Then base you chart off the values in the variable along with the slider values. I can't be anymore specific than that without some more information.

[jagannalla]

Hi Miller,

I attached my screenshots can you plz check it once.

-  If i selected BCShortfillingTimeA you can see ' N' value in the 'Avg' . Same value can you see in the straight table.

- Now i'll select another group then i'll get another 'N' value in the 'Avg'. But i should get the value in table box along with previous 'N' Value in straight table.

eg: 522 + 32 =554

[#4]

HI Jagan,

use peek, it must work for you

see the below example. B is the 'N' field for you. Replace B with N in the below formula

LOAD A, B, numsum( B, peek( 'Bsum' ) ) AS Bsum...;

Regards

Sravan

[rwunderlich]

You can union the current selections and the previous selection together using a set in your expression. $1 indicates the previous selection. For example:

=sum({$ + $1}SalesAmount)

-Rob