Help please

[#1]

I@m collecting data direct from a spreadsheet sheet with several years of data entered with individual day lines

I want to show the last 6 months average value by consecutive month

I.e.

I have the Dimension “Downtime date” a daily date reference

I have a second dimension “log type" which separates the items into 4 categories to show by price

( I also have available “Downtime Month” or “Downtime year”

I have an expression AVG “invoice price”

Could you help me with the modifications to the expressions to pick up the  "last" 6 months info as I only seem to be able to pick an individual years month and not run across 2 years

thanks

[Gysbert_Wassenaar]

Perhaps this document helps: Calculating rolling n-period totals, averages or other aggregations

[#3]

Hi,

Hope it will help u to complete u r task,

use straight table for this

dimensions :  Downtime date,log type

In Expressions tab:

under Accumulation->  click on check box  Accumulation -.> set steps back to 6

Expression : sum({<Downtime year={2015}>} invoice price)

Hope it will helps u.

Thanks and regards

Balaji.k

[#4]

* INLINE [

    college,name, score

   ?a,  1, 50

   ?a, 2, 60

    ?b, 3, 70

   b, 4, 30

   b, 5, 30

   b, 6, 30

  

]



where Left(ltrim(college),1)='?';