Total in straight table for each dimension

[Raj_P]

Hi Team,

I need help to produce total for each dimension and it should be visible against first instance of dimension as total.

Below is data and I want to create last column "state total".

country	company	department	revenue	state total
Sweden	abc	aa	100	600
Sweden	xyz	bb	200
Sweden	ppp	cc	300
Japan	lmn	dd	400	1500
Japan	opr	ee	500
Japan	qst	ff	600

[StarinieriG]

Hi,

you could try this

If(Len(Aggr(Sum(revenue),country))=0,' ',
Aggr(Sum(revenue),country))

[SukumarBera]

Please try this -

aggr(sum(revenue),country)

Regards,

Sukumar Bera