Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
I have had some inconveniences to be able to get the percentage horizontally, for example:
I have tried the following:
=Count(Ticket)/rangesum(before(Count(distinct TICKET),0,ColumnNo(TOTAL)))
Is it possible to position a column on the right where only the totals of the previous columns are shown?
It is just giving me the percentage of the current column with the previous column ..
Help me please
Could this expression solve this issue?
=Count(Ticket)/count(total <Name>Ticket)
If you are expecting last 2 column you required workaround using Inline table to match exact required output with measures. Can you please attach sample QVF to get the output?
Thank you very much for your answer, however it does not solve my problem.
I add image of my table.
I need to get the percentage of the total that I mark in yellow.
Example:
2021-03-05
# / Total Horizontal (the last record in the row)
2021-03-06
#/Total Horizontal (the last record in the row)
2021-03-07
#/Total Horizontal (the last record in the row)
You must take the last record of the stack of the row that is marked in yellow (Total Horizontal)
It is possible that the columns that are marked in blue do not show the amount and only see at the end of the row what is the horizontal total marked in yellow?
Best regards