product selection

[#1]

I have requirement, where we have multiple products and some of them are Brands and competitors. I got to show two charts

1. show only branded item sales line chart

2. if user select brand product P1 all competitors and the selected brand products (P2,P3,P1) sale should show.

Please find the attached sample app.

is this feasible ?

LOAD * INLINE [

    Date, Product,Type, Sales

    20130101, P1,Brand, 10

    20130201, P1,Brand, 15

    20130301, P1,Brand, 5

    20130401, P1,Brand, 10

    20130101, P2,Competitor, 20

    20130201, P2,Competitor, 10

    20130301, P2,Competitor, 30

    20130401, P2,Competitor, 5

    20130101, P3,Competitor, 10

    20130201, P3,Competitor, 30

    20130301, P3,Competitor, 25

    20130401, P3,Competitor, 30

    20130101, P4,Brand, 20

    20130201, P4,Brand, 40

    20130301, P4,Brand, 30

    20130401, P4,Brand, 35

];

[#2]

SET ANALYSIS thare are a function you can do this !!!!

[#3]

sum({1 - $} Sales)

Returns sales for everything excluded by the current selection.

[#4]

Workit introducing the next in your exppesion for sales

sum ({1 - $} Sales)

[jagan · Accepted solution]

Hi,

PFA file for solution.

Regards,

Jagan.