How to calculate Fees to Date

[#1]

Hi,

I have to calculate Employees Fees to Date in straight or pivot table. can anyone give example of how to consider dimension and expression.

I have EmployeeID and Sum(Fees) where FeeType=Gross

Thanks.

[#2]

Any help please

[Gysbert_Wassenaar · Accepted solution]

Create a straight table with EmployeeID as dimension and sum({<FeeType={'Gross'}>}Fees) as expression. Make sure you use the exact case-sensitive names of your document.

[MayilVahanan]

HI

Try like this

  EmployeeID -> Dimension

Sum({<FeeType={'Gross'}>}Fees) -> Expression

[#5]

Hi,

Thanks and if I want to see only Total instead of individual EmployeeID means what can I do. please let me know.

[#6]

Hi,

Thanks and if I want to see only Total instead of individual EmployeeID means what can I do please let me know.

[Gysbert_Wassenaar]

Remove the dimension so only the total is returned. Or use the expression in a textbox.

[christian77]

Hi:

In that case set the table with no dimension o place the expression they told you in a text box.

If you want that year to date, add in your set Año={'$(vAñoActual)'}, Mes={'$(vMesActual)'}, where vAñoActual=max(Año) y vMesActual = max(Mes) in your var pannel.

Amelia, tienes que leerte la ayuda de la máquina.

[#9]

Thanks and it's working.