horizontal total in Pivot Table Qikview

[kiranpatil123]

Hi All , 

Unit	Count of Product	Count of Article	Count of Material	Total
A	10	1	100	111
B	20	2	200	222
c	30	3	300	333
D	14	4	400	418
E	18	5	500	523
Total	92	15	1500	1607

I have above Table . I need horizontal Total ( Colored in green ) . 

Help me with Expression using rangesum or Secondary Dimesnionality or any other way .

Note that Count of Product , Article ,Material are 3 different expression 

[sunilpaul · Accepted solution]

Hi,

use the following expression as additional Measure :
= Sum([Count of Product]) + Sum([Count of Article]) + Sum([Count of Material])
* replace Count of Product , Article ,Material with their expression in above expression.

Regards

[Frank_Hartmann]

Add a fourth expression:

Column(1)+Column(2)+Column(3)

[kiranpatil123]

Thanks SunilPaul

That's Simple

I think i over thought too much 🙂

[sunilpaul]

Happens 🙂