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
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
Add comment