Group values by period

[claudio_reis_we]

Hello,

Could you help me please?

I am using a simple table chart and I need to add the value of two or more periods. My main question is how to make the sum of the results to display in a single period.

Example. Jan/2015 = 10, Feb/2015 = 20

This illustrates:

Period        Value

Jan/2015         30

Thank you,

[Anonymous]

If you have a Master Calendar you could create a new dimension for [2 Month Period] with something like this :

     MonthName ( makedate ( Year ( [YourCalendarDate] ) ,  ( 2 * ceil (  Num (Month( [YourCalendarDate])   / 2 )   )  )  -1 ) )   

[Gysbert_Wassenaar]

Perhaps like this: sum(TOTAL Value)

[MarcoWedel]

Hi,

one solution using a calculated dimension:

hope this helps

regards

Marco

[claudio_reis_we]

Hello Marco,

Hello Marco,

His statement works partially, maybe I have not used properly. I'm sending a picture to who can view and see if it fits in this situation.

Each year will have the sum of the quantity of the last 12 months. In this example 2016 is the amount this year + amount of 10 months of 2015.

Thank you.

Thank you.

[MarcoWedel]

please post a sample application and your expected result

regards

Marco