Toggle parameter to display value in percent or number value

  • gjoelson 29755

    Right there with Babe

    Points: 750

    Hello,

    I'm trying to see if I can toggle report values from a number value to a % value , using a parameter or other mechanism.

    My values in the dataset present as a number, but have a need to view that same number as a % of a total.

    I'd like to do this in the report itself rather than the dataset if possible.

     

    Thanks!

  • drew.allen

    SSC Guru

    Points: 76735

    The easiest thing is to probably have two fields one with the number and the other with the percent of total and to load one as visible and the other as not visible.  The initial visibility could be hard-coded or based on a parameter. You could also have a button to toggle the visibility of both fields.

    Actually, I'd prefer it if both fields were always visible on the report.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply