4 Replies Latest reply: Dec 11, 2017 8:10 AM by Ibrahim Aslan

# Table Chart Calculated Total in Additional Field

Hi Guys,

I want to show in a table chart following total field:

Data:

PersonWorking HoursCostsMonth
P135100003.2017
P136130004.2017
P13190005.2017
P245100003.2017
P254200004.2017

Person sum(Costs) sum(Costs) sum(Costs) Month 03.2017 04.2017 05.2017 Total (Working Hours) 80 90 31 Total (Costs) 2000 3300 900 P1 1000 1300 900 P2 2000 2000 -

I know how I can show Total sum of Costs, but how can I show Total sum of Working Hours without a column in Expressions?

• ###### Re: Table Chart Total Additional Field

May be this?

• ###### Re: Table Chart Calculated Total in Additional Field

Hi Anil,

this is good. But what exactly do you make with Dim and why Dim is from 1-3?

• ###### Re: Table Chart Calculated Total in Additional Field

To customize the special adding(not existing the rows) for special rows, I am creating sequential numbers using Dim which has 1,2,3 because In UI it showing Person, Costs, Hours. That means i am allocating to each Dim value to Person and Costs and Hours. After that i made expression to fit each dim of all measures for customize one..

Does it make sense ??