Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have attached the .qvw file and excel source file.
My requirement is
For material group PEN I need to give user a selection of SKU, whatever user select the value of SKU of PEN
that much of data should be visible in chart.
Got it. Here is one more way to do in Set Anlaysis and the expression is:
If (getfieldselections(SKU) > 0,
Sum({1<[Material group]-={'PEN'}> + <SKU ={'$(=getfieldselections(SKU))'}>} Sales),
Sum(Sales))
See the attached file for the chart. Hope this helps.
Please see the attached qvw file where I created a list box based on your requirement. Hope this helps.
Hi
Thanks for your reply,
When I select any sku value material group pen the other data of other material group of the chart should not disturb.
for example if I select BALL PEN of material group PEN then as per the attached excel the chart value should come.
Right click the object you want to remain unchanged and select "Detach"
Edit: sorry, misread the example attached. I will take another look
Try this as your expression in the "Sales" object:
IF(MATCH([Material group],GetFieldSelections([Material group])),
SUM({<[Material group]=>}Sales),
SUM({<[Material group]=,SKU=>}Sales))
Got it. Here is one more way to do in Set Anlaysis and the expression is:
If (getfieldselections(SKU) > 0,
Sum({1<[Material group]-={'PEN'}> + <SKU ={'$(=getfieldselections(SKU))'}>} Sales),
Sum(Sales))
See the attached file for the chart. Hope this helps.
For Selecting single value your solution working fine.
If I select more than one value then it is not working.
Please check.
I am able to select it. Please see the screen shot below: