Skip to Content
0
Former Member
May 14, 2013 at 07:35 AM

How to calculate the Key Figure based on a Single row of a Structure in Crystal report

220 Views

Hi,

While creating a Report in Crystal Reports 2011, was trying to fetch a Bex Query which had a Characteristics Structure in it. But my Report needs a Key figure to be calculated based on the single row of a Structure.

IE : If my Characteristics Structure had 5 rows, i need the Key figure to display only the value of 3rd row in that Structure.

eg:

If my Bex query has a Structure named India-Population-2011 as below

India-Population-2011

Delhi 16.31M

Mumbai 18.41M

Kokatta 4.48M

Chennai 4.68M

Now i need to display a Crystal Report only for Chennai using the Bex query as above

Chennai Population - 2011:

Chennai 4.68M

Thanks,

Sowmya Sharma.