exclude selection in bar chart

[vengadeshpalani]

ID	Transportation
A	Car
A	Bike
A	Bus
A	Cycle
A	Ship
B	Car
B	Bus
B	Airplane
C	Car
C	Bus
C	Airplane
C	Ship
D	Cycle
D	Car
D	Helicopter
D	Boat

when I click B from ID list box

its related Transportation is Car,  Bus, Airplane

but business user need bar chart like

A=2 (because it have Car and Bus)

C=3 (because it have Car, Bus, Airplane)

D=1  (because it have CarBus)

Note:

I can't use Cross Table for this because it affect Data model

[Siva_Sankar]

Find the attached application. Do you want something like this?

[sunny_talwar · Accepted solution]

May be this (using shankarece‌'s attached sample)

Count({<ID = E(ID), Transportation = P(Transportation)>}Transportation)

[vengadeshpalani]

u always awesome

Thank You Sunny.......