total of dimension

Report Inappropriate Content · ‎2012-10-25

Please check the attached file and let me know how to calculate the total of "Actif" . Actif is a dimension.

Thanks,

Nima

Gysbert_Wassenaar · ‎2012-10-25

Add an expression =sum(Actif) to your (pivot)table/chart

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2012-10-25

I don't want to repeat it for every single column.

Gysbert_Wassenaar · ‎2012-10-25

I don't understand what you mean. Can you explain? Can you share the qvw document you're working on?

talk is cheap, supply exceeds demand

Report Inappropriate Content · ‎2012-10-25

If I add sum(Actif) in expression then It will create sum(Actif) for every column.

What I want to do is for example equipe 8 is 120 and equipe 12 is 81 , I want to have 201 as the total for the line that you see the Total right about them.

Report Inappropriate Content · ‎2012-10-25

remove Actif as dimension & add first expr:

sum(aggr(sum(Actif),Annnée,Mois,Équipe))

Report Inappropriate Content · ‎2012-10-25

it does not change any thin

Report Inappropriate Content · ‎2012-10-25

Check Show partial sum on presentation tab for each dimension

Report Inappropriate Content · ‎2012-10-25

this is not an expression . it should be a calculated dimension . Maybe I did not explain it well.

MayilVahanan · ‎2012-10-25

HI

Can you post a sample file?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Related Topics