Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reporting format Issue .. Result row Count Display...URGENT!!!!

Hello All,

Need solution for my issue in reporting,

This is my Report format

Date A/c number Kf1 Kf2 Kf3

01.06.07 123 10 20 0

234 20 30 30

456 50 0 25

789 0 25 0

Result 80 75 55

01.07.07 124 10 0 10

134 30 30 30

457 40 0 0

788 0 25 10

Result 80 55 50

Now my requirement is to display Count in the result row as

Date A/c number Kf1 Kf2 Kf3

01.06.07 123 10 20 0

234 20 30 30

456 50 0 25

789 0 25 0

Result 3 3 2

01.07.07 124 10 0 10

134 30 30 30

457 40 0 0

788 0 25 10

Result 3 2 3

and to be more precise this is my requirement

Date Kf1 Kf2 Kf3

01.06.07 3 3 2

01.07.07 3 2 3

I made key figure Calculate Result as Count <> 0 and Calculate single value as Supress Result for each key Figure and A/c Number No display I got result like this showing all data as blank, however the rows will exist.

Date Kf1 Kf2 Kf3

01.06.07

3 3 2

01.07.07

3 2 3

But I need my result should be like this

Date Kf1 Kf2 Kf3

01.06.07 3 3 2

01.07.07 3 2 3

How can I Acheive this either by work Book Or by Query ,

Please help me

Thanks for all ur support in advance

Sai.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question