Average Sum constant value

Q&A
, ,
1

I want to calculate the total revenue and display it as same for all rows irrespective of categorisation in the table.For average i want to see total revenue/ total no of customers.But since total or Over functions are not available right now how to do this…In short if i put sum(revenue)in KPI i will get a value i want that value to be displayed in my Table irrespective of what the rows are

2

@vinay-vikram you can use Sumover function.

3

Thank you will.check it out