Skip to Content
0

Aggregating days to month

Mar 07 at 12:24 PM

18

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 07 at 12:31 PM
0

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 .

Share
10 |10000 characters needed characters left characters exceeded