Straight table showing incorrect values

[#1]

Hi,

I need to show sum(salary) for each employee based on dates in straight table.. I used employee in dimension and in expression I used Sum(Salary).

It's showing incorrect values.

Could anyone help me how to write the correct expression to get values.

Thanks.

[jchoucq]

Hi,

the expression you wrote seems ok.

Maybe, in you source, you have many data for the same employee on differents months.

Do you have a Year or a month field in your data model ?

johann

[srchilukoori]

Are you trying to calculate the salary based on both employee and date? if so you need to add both date & employee to the dimensions.

[mdmukramali]

Dear ,

can you share the sample apps.

Thanks,

Mukram.

[#5]

Thanks and can I know how to write expression in dimension to get last month amount

[Clever_Anjos]

If you need to show "based on dates " shouldn´t you add "Date" as a dimension?

[#7]

Hi,

I need to show last month salary ,current month salary and To date salary. Is it possible to get these figures?

Thanks.

[Clever_Anjos]

Yes, its possible, just playing around with Set Analysis

CurrentMonth = sum({<yourdatefield={">$(=monthstart(today())"}>}Salary) and so on...

[#9]

Thanks and with the same values when I am trying to create chart, and when I am selecting fiscalyear 2013-2014 it is showing negative(minus) values on Y-axis. can you let me know do I need to change anything in axes?