Get cumulative total value on x-axis.
i'm displaying:
january $200
february $100
march $400
i want display:( i've set custom mmm on axis-properties, still months not getting below required format)
jan $200
feb $100
mar $400
total $700 on x-axis.
and want y-axis divided in intervals of 200, though i've set interval 200, displaying in divisions of 2000.
hi shivn,
from information, want display jan feb mar.... rather january february march ....to achieve requirement, follow there steps below:
1. right-click datafield on x-axis, , select category group properties
2. click fx button @ of drop-down list of label
3. type in expression=left(fields!month.value,3)
then want.
best regards,
challen fu
SQL Server > SQL Server Reporting Services, Power View
Comments
Post a Comment