How to show a metric without Calculation in a pivot table

[MMK]

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]

What is the logic for the example from img?

We have 5 rows where Country and State are nulll

[MMK]

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.