SUB Totals

[roee1983]

Hi All,

Need your help..

Please find attched table

is it  possible to make  sub totals llike :

a+b

a+b+c

a+b+c+e

a+b+c+d+e

it can be in strait table or pivot

Thanks

Roee

Roll	Sum
a	10
b	5
c	4
d	3
e	2

[fkeuroglian]

Hi Roee

se the attached

hope help

Fernando K.

[sunny_talwar]

Sub-totals? can you elaborate how your solution should like if what fkeuroglian‌ provided doesn't work for you?

Best,

Sunny

[qliksus · Accepted solution]

hi,

Maybe something like this

Subtotal:
LOAD * INLINE [     
    Roll,Sum  
    a ,10
    b ,5
    c, 4
    d ,3
    e, 2
];

for Each a in  'ab','abc','abce','abcde'

load

*,
if( SubStringCount('$(a)',Roll),'$(a)') as Group

Resident Subtotal ;

NEXT

DROP Table Subtotal;

[#5]

Hi Roee,

Please find the attachment, i hope it will help you.

Thank you !

Nandu

[fkeuroglian]

Nanda

Same xls

Same set expression

Same objects

Same result

Different qvw name

Really?

[sunny_talwar]

I hate when people do that

[roee1983]

Hi,

Thank You

Which Dim and Exp did you use ?

Thanks

Roee

[beck_bakytbek]

Hi Susant,

did you do this example on the base of straight table?

thanks

beck