Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
in app I want to show amount of insured accounts receivable, where amount of accounts receivables exceeds insured amount.
In my table I have insured amount for each company and amounts of accounts receivable as well - of course there could be multiple insert for each company (as export is done on invoice level)
If I show this in a table , everything is ok (as I have dimension Company), but I also want to show amount in KPI report. The issue I'm facing is that if I want to show it in KPI report is that I need to define dimension (company ), which I do not want to have as I need only total amount.
If maybe someone has a solution?
Is it possible in KPI report to define Measure for Company and hide this dimension, as I need only total amount of the amounts exceeds Insurance
Thank you in advance
Something like
Sum(Aggr(Sum(TOTAL Amount), Company))
might work