Skip to Content

Aggregating days to month

Hello WebI Experts!

I have one (maybe simple) question. I have one dimension and one measure in my reports: dimension - Target Date, measure - Number of POs.

Target Date // Number of POs

16-01-01 // 80

16-01-02 // 12

16-01-03 // 35

16-01-04 // 10

16-02-01 // 7

Which formulas can I use to aggregate the days to the month? I used almost all of them and it still doesn't work. Below the result I want to achieve:

Target Date // Number of POs

16-01 // 137

16-02 // 7

Thank you in advance 4 all comments!

BR,

Kamila

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 07 at 12:31 PM

    If target date data type is date then right click on the date->format number->date->custom-"yy-MM" place.it will convert the dates in yy-mm format.Assuming number of POs is already a measure object with sum function.

    or create variable V date=formatdate([Target date];"yy-MM")

    Drag V date and POs objects in the table and it will automaticlly sum .

    Add comment
    10|10000 characters needed characters exceeded