Grouping products as a single value

[udaya_kumar]

Hi,

i have a scenario for Adhoc like,

i have a listbox with product names, when i select few products, then those products should be grouped together as 'other group'

i will have a table,

when i select some values in product listbox, then those selected values are grouped and the volume for those products are calculated and show as one row as 'other group' with its sum(volume).

the table should show those unselected products and that group 'other group' with their corresponding Sum(Volume).

how we can do this?

[SunilChauhan]

see the attached file

hope this helps

[SunilChauhan]

or may be you are looking for this

see attached file hope this helps

[udaya_kumar]

Products	Sum(Volume)
a	100
b	200
c	150
others (d,e)	900

Hi Sunil,

thanks for reply,

ya i want almost that kind of thing, but one more thing in that,

in second file which u uploaded, it shows sum of selected products as some value 900 and

i need unselected products also shown with that group as individual

something like the mentioned table

the grouped products should be shown as others and unselected products should show as different row in the table. and also these products should filter based on markets selected.

there are few markets like biologic, rheum , derm.

the no of products varies based on the market selection.

so here the products should filter based on the market selection and even it should show this grouping.

if i dont group products, if i select some market, then it should show all the products and its volume based on market,

but if i select and group products based on market, then the table should show the products based on market and even the grouping should be shown

[swuehl]

If you are using QV11, I think you can do this using dimension limits and two expressions defining your two sets you need. The first expression is only used for the dimension limit and hidden in presentation tab.

Please see attached.

[udaya_kumar]

Hi swuehl,

thanks for reply,

i wanted that only, but the problem is, am using pivot table. so dimension limit tab is not visible for pivot table.

i have one more field month name, so am placing that at the top of the table as column. so i need to use pivot table for that.

[swuehl · Accepted solution]

Ok, here is a different approach not using dimension limits, but partial sums in a pivot and checking for dimensionality().

[udaya_kumar]

hi swuehl,

thank u very much for the help

u rock