Skip to Content
author's profile photo Former Member
Former Member

Display the Result Row only with the characteristics

Hello Gurus,

I Have an urgent requirement.i need to display the result row along with the characteristics and not the key figure data as such.

To explain:

i need to show the min, max and average price(among a range of prices offered to different distributors) of a particular product .

what i have done is in the KF properties i have selected "Show result as min" for min and so on..

What i am getting right now is:

Prod******MIN****MAX*******AVG

ABC*******1******1*********1

**********1.1****1.1*******1.1

**********1.2****1.2*******1.2

________________________________________

Result****1******1.2*******1.1

But what i want to show is

Prod******MIN****MAX*******AVG

ABC*******1******1.2*******1.1

Please Help

I promise to reward points to the helpful answer.

Thankyou Soooo Much

Regards

Priya

P.S:kindly ignore the asteriks. They are just to make the text more easily readable.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2006 at 10:51 AM

    Hello Bjorn

    Thankyou for replying soo quickly to my query.

    I tried what u had suggested - still it displays the keyfigure data.My requirement is to only show the result line along with the product name ( which is a characteristic)

    Plz Help if u can..

    Paolo , thankyou to you too for replying soo early.

    But i am not using excel sheet to display the query result. i have to display the query in Web Application Designer.

    Through class, it would be possible but i felt that- writing a class for it would be a dirty work around. There should be a simple way to acheive this.

    Plz Help if u can..

    Regards,

    Priya

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Bjorn,

      Thankyou soo much for solving it 😊

      i was also doing much the same except that i had set the reference to product and it was suppose to be distributor ( as u suggested)..

      Thanks a ton for answering my query.

      i've assigned you points.

      Best Regards

      Priya

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2006 at 08:49 AM

    Hi Priya,

    remove Prod from drilldown and define three calculated key figures based on price. Define exception aggregation 'minimum' for first, 'maximum' for second and 'average' for third CKF select Prod as exception characteristic.

    Best regards,

    Björn

    EDIT: Sorry, misunderstood your requirement, you need to display also Prod....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2006 at 09:03 AM

    Some VBA code to hide the detail. On the properties, turn off suppression of repeated key values so you'll get the key/text value for the characteristic(s) on the result line. You'll have to adjust the highlightes code based on rows to begin suppressing and columns to check for "Result".

    Sub remove_detail()

    For rownum = 18 To 64000 Step 1

    If Cells(rownum, 2) = "" And Cells(rownum, 3) = "" Then

    lastrow = rownum - 1

    Exit For

    End If

    Next

    For rownum = lastrow To 18 Step -1

    If Cells(rownum, 2) = "Result" Or Cells(rownum, 3) = "Result" Then

    Rows(rownum).Hidden = False

    Else

    ' Rows(rownum).Hidden = True

    Rows(rownum).EntireRow.Delete

    End If

    Next

    End Sub

    Hope it helps.

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2006 at 08:45 AM

    Hi,

    Are the other 2 lines total result? If so, you can just right click on title Product and make sure that you suppress the total result.

    Cheers,

    Gimmo

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2006 at 10:58 AM

    I think this post could help you:

    Display Result rows and hide Detail rows in a web report !!

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Paolo,

      Nice thread. Thankyou.

      I'll try implementing it.

      But i was just wondering that there shld be a way to do it in a simple manner!

      I've assigned u points.

      Incase, u come across some other idea, please do share.

      regards

      priya

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2006 at 11:03 AM

    Hi Priya,

    Check the option 'Hide repeated key values' in the query properties and see.

    Also please let us know the contents of the rows in your query.

    Hope this helps you......

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.