topic Re: How to show a metric without Calculation in a pivot table in App Development

How to show a metric without Calculation in a pivot table

MMK — Sat, 08 Nov 2025 08:47:38 GMT

Hi Team,

Thanks for you support in advance.

I am having data at Country, State and Globe level.

if Country and State is NULL --> that data is Globe data

if only State is NULL --> that data is Country data

next case --> State level data

Except AN=987025, remaining all values are number, that particular value is percentage.

I want to show Values and Percentage in one Pivot table .

In a pivot table to want to show w.r.to Country --values 987024,987011,987025 values

robert_mika — Sat, 08 Nov 2025 07:51:32 GMT

What is the logic for the example from img?

We have 5 rows where Country and State are nulll

MMK — Sat, 08 Nov 2025 08:53:44 GMT

Hi Robet,

i attached sample data and QVF file also.

I want to know how to write expression for Column 3, That is the ratio of ANSTC/ANSIG, also in data i am getting that value under AN=987025.

In the 'image' i shown same data. Last row of that image shows value expecting in Column3.