Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Chart which displays the sale of a particular brand.
Like this (Fig 1)
Since, BMW can have competitors. I need to show that as another chart (instead of everything in a single bar chart)
Like this
So, this is how my dashboard works.
1. User clicks a brand in a List box provided.
2. Fig 1 shows the sales for that Brand.
3. Fig 2 shows the sales of it's competitors
Fig 1 requires a normal SUM(Sales) expression. However, Fig 2 requires values other than the one used in Fig 1.
I tried this using Set Analysis like SUM({<Brand={*}-{'BMW'}>}Sales)
This works only for BMW. I need to calculate the value dynamically based on the selection user makes. GetSelections functions are not working inside set. How this can be done?
Hi,
Try like this
Chart 1: for BMW
=Sum(Sales)
Chart 2 for Competitors:
=Sum({<Brand={'*'}>} Sales) - Sum(Sales)
Hope this helps you.
Regards,
Jagan.
Hi,
You must chek "Always One Value Selected" in your ListBox for your selections. This ListBox should be your field "Brand" and then use set Analysis like this:
=sum({$<Brand <> {GetFieldSelections(Brand)} >} Sales)
Hope it helped
HI,
Comparative analysis will help here
take one Flag competitor then split the Brand Filter in to 2 listboxes
use Set analysis with Alternate states if you want to see Company vs Competitors
Hi,
Try like this
Chart 1: for BMW
=Sum(Sales)
Chart 2 for Competitors:
=Sum({<Brand={'*'}>} Sales) - Sum(Sales)
Hope this helps you.
Regards,
Jagan.
Hi,
Please use the exclude function in the second chart to exclude the current selection.
SUM({<Brand=E({$}Brand)>}Sales).
Hope this will resolve the issue.
Thanks.
Please find attached file for solution.
Regards,
jagan.
Thanks Jagan for that quick and brilliant solution. Simply ingenious. Thanks.
For the second chart, you can use the e() function, to show the excluded brands:
SUM({<Brand= e() >}Sales)
Another great solution. Thanks