How to calculate the total percetage on table?

[kwl1234]

Total percentage should = 7154/27129=0.26370304839

How do I calculate the total percentage based on total value of Sum and GP?

I tried Column(3)/Column(1) also showing the wrong value(31.8%)

I also tried Sum(Total (Column(3)))/Sum(Total (Column(1))), but it is not working, return 0.

I also want to know about How to filter the dimension?

I want to filter B and C when I select year = 2021 and Month= 04.

I am filter the dimension by this expression:

If(Year & Month &99<Start Date, null(),Category)

Is there any proper way to doing that?

[MayilVahanan]

Hi @kwl1234 

Try like below

Sum(Aggr(Column(3) expression / (Column(1) expression) , Dimension1))

Column(3) expression <-- might sum(RevisedContractor)

[kwl1234]

Hi,

I tried the expression that you provide. it return the sum of  % =975.3%. however, I would like final total % = Sum of column 3/ Sum of column 1 which is 26%..

[MayilVahanan]

Can you send the sample file?