Ytd( [ member ] )
A valid Multidimensional Expressions (MDX) expression that returns a member.
with
member measure.SSSSSS as sum(Ytd(), (measure.[sales amount]))
select { (measure.[sales amount]), (measure.SSSSSS)} on 1,
YTD() on 10
from [Online Store]
where
(Calendar.[ALL].[2021].Q4.M12, [Payment Method].[ALL].[Credit Card]);
| sales amount | SSSSSS | |
| M1 | 480 | 480 |
| M2 | 480 | 960 |
| M3 | 480 | 1440 |
| M4 | 480 | 1920 |
| M5 | 480 | 2400 |
| M6 | 480 | 2880 |
| M7 | 2778 | 5658 |
| M8 | 2557 | 8215 |
| M9 | 2490 | 10705 |
| M10 | 2558 | 13263 |
| M11 | 2289 | 15552 |
| M12 | 2171 | 17723 |