Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I have a report in that I have sorted all as sum(sale) value
All values are coming sorted properly but I wants all 0 values should be at bottom
Please see attached.
Thanks
Can you attach some sample data?
You can sort them numerically in descending way, rather sorting in Alphanumeric values. This will help in putting zeroes together.
I am not able to share data but please find the image of that reports and values in highlighted in red and 0(green) will come in middle instated of bottom
Hi prma7799,
Try like this
I have already done this ..
I have 7 expression in my chart.
What are the dimensions? disable the sorting of others.
BTW, can you share us the screen of sorting?
Please find the attachment I have put sorting on highlighted column.
I have used below expression for sort.
(SUM({$<FiscalYear={$(=max(FiscalYear))}>}Value) )/100000
I have set sorting for all dimension