KPI - Use value from table/calculated value with Sum over


I would like to show a value (that is already visible in a table as total) in a KPI visualisation. For the table I use SUMOVER in my formula. Is there a way how to either use the value from the table in the KPI visualisation or how to include a calculated field that uses sum over?

Just create a calculated field in analysis and make a KPI Visual. Is that not working? BTW: SumOver Syntax

Hi, @Sunshine007. Did @Shekhar’s solution work for you? I am marking his reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!