Current and previous month

[mario-sarkis]

please i have a list of ID  and a period date and an ammount

i need to show a pivot table of the sum of ammount like  that

ID       CURRENT Month        PreVious Month       Lost Amount

how can i write the expression

[mario-sarkis]

Thank you settu, i can tell that your good in explaining

[mario-sarkis]

Hey Settu,

how can i show  the loss per month in a line Chart ?

coz once i selected on a month lets say: if my selection is on oct-2014 as (Current) the (Previous) is showns as (oct-2013) else i want it to show as sep-2014.

when no selection is corrected as your expression but it shows as an error in a line chart per month.

Hope you can help

[mario-sarkis]

Hi Settu settu_periasamy

I have a question for you, have any idea how i can calculate this Loss in text for all ids?

Please help

Thank you:)

[settu_periasamy]

Hi Mario,

Do you want all the ID's and Loss Amount in Single TextBox?,

Try this in your text box.

=(sum({<Date={'$(=Date(Max(Date),'M/D/YYYY'))'}>}Balance)-

   sum({<Date={"$(=Date(Max({1}{<Date={'<$(=Date(Max(Date),'M/D/YYYY'))'}>}Date),'M/D/YYYY'))"}>}Balance))

[mario-sarkis]

this is exactly wut i need , u have any Idea if i want to this Loss Amount as an evolution in a Line Chart ?

cuz it Shows me a  weird Amount.

Thanks alot,

[settu_periasamy]

if you post the sample, then will try find out..