Disable certain selection

[spcon2016]

Hello Community,

I'm trying to create a pie-chart, which disregards a certain selection. I have two list-boxes (customers and products) and in the middle of all a pie-chart. This one should only be modified by the customers-selection, not by the products-selection.

How I'm able to do that?

Here is the expression of  pie-chart:

FABS(SUM (SALES)) / FABS(SUM(TOTAL SALES))

I thought abou Set Analysis, but how I could achieve what I need? Where to implement? Many questions and many gaps in my mind.

Best regards

K.K

[felipedl]

Hi Kerim,

Use set analysis for this,

something like:

FABS(SUM ({<Products>}SALES)) / FABS(SUM({<Products>}TOTAL SALES))

This will not consider the selections made on the Products listbox, if I understood correctly, that's what you want to disconsider.

Felipe.

[prat1507 · Accepted solution]

Use

FABS(SUM ({<PRODUCT=>}SALES)) / FABS(SUM({<PRODUCT=>}TOTAL SALES))

[krishnacbe]

Try below expression to exclude Products selection FABS(SUM ({}SALES)) / FABS(SUM({}TOTAL SALES))

[krishnacbe]

Sorry Typo FABS(SUM ({}SALES)) / FABS(SUM({}TOTAL SALES))

[krishnacbe]

FABS(SUM ({ PRODUCT= }SALES)) / FABS(SUM({PRODUCT= }TOTAL SALES))