Display Problem with the Key Figures

[Former Member]

Hi,

I working on the query where i need to display three Key Figures. I have no problem with the first two Key Figures , but the third Key figure values need to be display by day wise. (0Calday). i.e., the third key figure value should be displayed based no of days 0Calday has.

For Example if 0Calday is holding 4 days... then third keyfigure Value should be display as 4 columns with their respective values by dividing into day wise, remaining first two key figures should not be changed.

When i am trying to call the 0Calday into the Column, all the three Key Figures values are displaying as many as no of days 0calday has.

For Example if 0Calday has 2 day....the three Key Figures are values are breaking into two days values and displaying, so totally we can see 6 Key figure values. But i need first two values should not break but the last key figure should be divide into two days as values and display.

Thanks & Regards

Agama.

[Former Member]

hi Venkata

Will You please let me know the exact structure..

what do you have in rows? some other Characteristics than 0Calday ...right?..Is it something similar to below one for third calendaer day?

Compcode Keyfig1 Keyfig2 Keyfig3-Calday1 Keyfig3-Calday2 Keyfig3-Calday3

C1

C2

C3

...

...

Please confirm..so that I can suggest a solution?

Let me know the corrections If I am wrong.

--Nandita

[Former Member]

Hi,

You are right.... rows contains some other characteristics.

column contains Key Figures and 0calday.

The example give by you exactly matches....

Thanks for understanding my issue.

Please help me in solving this issue.

Thanks

[Former Member]

Hi Nandita....

waiting for your reply....

Thanks.

Edited by: Venkata Jagannadha Raju Dantuluri on Jun 30, 2009 8:28 PM

[Former Member]

Hi,

Please any one can help me in this issue.

Thank you.

[Former Member]

Hi Venkat

This can be achieved by supressing 0 values.

1) In the Query Designer: Go toquery properties

2) Select Suppress Zeros

3) Select option Active

4) Under Effect On : try with Column or row o (Not infront of system , so cannot exactly remember)

This will allow you to get the exact result as per your requirement. We had the same issue and we could resolve this by following this.

Hope it helps.

Cheers