Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
There are two Measure selections(Measure and NEW) in the report according to which the chart should appear.
the output required:
For any selections in Measure the Total of those columns should appear.
Similarly if any selection from NEW then the Total1 of those columns should also be implemented in the chart.
issue:incorrect total1 and any selection for NEW does not Hide.
Appreciate your effort.Thanks
Regards,
Shreya
Try this
RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=GetSelectedCount(Measure)+1),$(=GetSelectedCount(NEW)+GetSelectedCount(Measure)-1))&')' ),2)))
Yes when i dont select anything from NEW i am still able to see expressions from NEW.
Also the Total1 expression RangeSum($(=mid(Concat(',Column(' &ValueLoop(1,$(=Count(NEW)-1))&')' ),2)))
is giving incorrect output.
Thanks
Try this for total1
RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=Count(Measure)+1),$(=Count(NEW)+Count(Measure)-1))&')' ),2)))
and use this for your NEW expressions
=SubStringCount('|' & Concat(distinct NEW, '|') & '|', '|Z|') and GetSelectedCount(NEW) > 0
the calculation condition for the chart which i have given is an issue
=GetSelectedCount(Dimension) > 0 and GetSelectedCount(Measure) > 0
which means i must select Measure(mandatory).
But the selection can be from any MEASURE OR NEW. or Both
how do i handle that situation.
Thanks.
trying to understand the expression
RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=Count(Measure)+1),$(=Count(NEW)+Count(Measure)-1))&')' ),2)))
?
how does this work? Thanks
@shreya_nadkarni wrote:the calculation condition for the chart which i have given is an issue
=GetSelectedCount(Dimension) > 0 and GetSelectedCount(Measure) > 0
which means i must select Measure(mandatory).
But the selection can be from any MEASURE OR NEW. or Both
how do i handle that situation.
May be try this
=GetSelectedCount(Dimension) > 0 and (GetSelectedCount(Measure) > 0 or GetSelectedCount(NEW) > 0)
@shreya_nadkarni wrote:
trying to understand the expression
RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=Count(Measure)+1),$(=Count(NEW)+Count(Measure)-1))&')' ),2)))
?
how does this work? Thanks
It is ValueLooping from end of Measure expressions till the end....
if nothing is selected from Measure
the REQUIRED OUTPUT chart TOTAL1 is coming incorrect.
Try this
RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=GetSelectedCount(Measure)+1),$(=GetSelectedCount(NEW)+GetSelectedCount(Measure)-1))&')' ),2)))
Thanks a lot Sunny for all the help.(y) 🙂