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.

[MK_QSL]

1) UPPER(MODELS)

or better to change in the script itself..

UPPER(MODELS) as MODELS,

Try this in your script...

T1:

LOAD UPPER(SECTIONS) as SECTIONS,

     UPPER(MODELS) as MODELS,

     VALUES

FROM

DATA.xls

(biff, embedded labels, table is [Sheet1$]);

join

Load 'TOTAL' as MODELS, SUM(VALUES) as VALUES Resident T1;

[#3]

Sorry it does not meet my requirement

can you share the app win which you got the result

[jyothish8807]

PFA

Regards

KC

[#5]

Hi Jyothish

thanks for reply

i need the Total value as sum of those 3

ex: 1 + 2+ 3 as 6 i need it in seperate in column

and also i need total as 4tth value in list box as well

[#6]

Suggestion required

[ecolomer]

Is this you need?

DATA:

LOAD

      Upper(SECTIONS) as SECTIONS,

      Upper(MODELS) as MODELS,

     VALUES

FROM

(ooxml, embedded labels, table is Sheet1);

[ecolomer]

or this ...?

DATA:

LOAD

      Upper(SECTIONS) as SECTIONS,

      Upper(MODELS) as MODELS,

     VALUES

FROM

(ooxml, embedded labels, table is Sheet1);

join

Load

  'TOTAL' as MODELS,

  'TOTAL' as SECTIONS,

  SUM(VALUES) as VALUES

Resident DATA;

[#9]

Almost

in the pivot table again I need multi pack + dual pack as a single column

[#10]

In the pivot table I need multi pack + dual pack+ single as Total

and Mulit+ Dual  as another column