Comparing years and months

[#1]

Hey I am trying to compare sales by years and months meaning

February 2014 sales vs February 2013 sales how can I preform this?

And how can I show it on percentages?

I am adding a picture of my app

[Chanty4u]

go through

How to create MTD,YTD,PMTD and PYTD

[#3]

hey sureshqv , tnx for your help but i belive the soultion will be changing / applying things on the App itself....

[#4]

i need the user to have the ability to change it manually...

[reddy-s]

Hi Jhonatan,

From the description of the problem, I think you need some thing like this. When 2014 and  Feb is selected, the results should be compared to 2013 - Feb right?

If so check this out:

- Sangram

[#6]

Exactly !! yes thats what i need how can i do it ?

[reddy-s]

Hi Jhonatan,

Just create two measures like this:

1) sum([Field])

2) sum({$< Year = {'$(=num((GetFieldSelections(Year) - 1), '###0' ))'}>} [Field])

Create these measure and make use of them in your chart.

As @sureshgv mentioned, the best practice is to do it in the script which gives you better performance.

Hope this helps!

- Sangram

[#8]

if i have Sum(sales)  as measure,

that means i have to put in the GetFieldSelections?

[#9]

would mind to help me with syntax?

year=year

sales = sum ( iv_cost)

[reddy-s]

Hi Jhonatan,

Then just use these expressions:

1) sum(sales) - assuming year 2014 is selected

2) sum({$< Year = {'$(=num((GetFieldSelections(Year) - 1), '###0' ))'}>} sales) - this will give you the sum of sales for 2013 considering any other month or quarter selections as well.