I have done simple Ad-hoc report,
if i make selections Dimension = Year and Measure= A,B,C and Total
here total working fine 1550, total calculation A+B+C.
MY requirement, if i make single selection Measure= A and Total, i have to show my total, my total not showing because,
i have written my expression Column(1)+Column(2)+Column(3),
and if i'm make selections A, B and Total, i need to show based on selection Total.
same as A, C and Total
How to write expression total ?
Thanks in Advance...
Try below expression for Total
if(SubStringCount('|' & Concat(distinct Measure, '|') & '|', '|0 - 30|')=1,Column(1),0)+
if(SubStringCount('|' & Concat(distinct Measure, '|') & '|', '|31 - 60|')=1,Column(2),0)+
if(SubStringCount('|' & Concat(distinct Measure, '|') & '|', '|61 - 90|')=1,Column(3),0)
this expression already i had tried, problem is if i make selection order only working fine.
suppose, if i make selection 31-60, 61-90 and total. Total not showing.
Yes, you are right, and this is because the Total column itself is getting added in such scenarios. I have got a more dynamic (a bit tricky too) expression. Try :
RangeSum($(=mid(Concat(',Column(' &ValueLoop(1,$(=Count(Measure)-1))&')' ),2)))
Perhaps not. Because of two reasons: