Calculation in Pivot Table and List box

[#1]

Hi,

I am sharing the excel sheet and sample app in that i need

1)  In list boxes every field should appear in UPPER CASE.

2) In the Selections box i need to have one more value as TOTAL with summing up the values of "DUAL PACK, MULTI PACK and SINGLE"  ( List box should appear with 4 values exsting 3 and TOTAL)

3)  In the pivot table I need to have TOTAL filed which shows the sum of three other fields and as the other column with DUAL PACK+ MULTI pACK data as DUAL

can some kindly provide me the suggestions on this

i was experiencing the different results as i am performing the set analysis.

[ecolomer]

here ...

[ecolomer]

see the last file upload

[ecolomer]

[#5]

thanks

but the calculations are accurate

[Anonymous · Accepted solution]

see attached.

[Anonymous]

see attached.

shows only total and dual columns while using pivot table chart object.

glad to help.

[#8]

Glad to receive your suggestion once again

cant we do generic load in straight table

can you provide me the sample or kindly have a look at this post

Straight table