Skip to Content
avatar image
Former Member

Ranking + Percentage issue

Hello all,

I have very simple table : [dimension], [measure], Percentage ([measure]) + few filters and input controls based on other dimensions.

Everything works nice and as expected.

The issue is when I apply Rank i.e. top 10 on this table. Calculated column "Percentage ([measure])" didnt calculate results as I expect, Percentage function uses only top 10 values. I need to calculate percentage from all not only top 10 values.

Normally for this issue there is workaround with function NoFilter(), but this can be used only if in report arent other filters or input controls.

What I need is something like NoRank() function, so not all filters and input controls arent ignored.

Please any ideas how I can achieve what I need?

Thanks for any help!

Rudolf

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 20, 2015 at 11:31 AM

    Hi Rudolph,

    Will using the Nofilter option on your query help?

    It will depend on your formula and filters used but there are a few options parameters as In Block / In Report etc that you should be able to use to achieve the 10 Dimensions % based on the overall value of the report.

    With regards

    Gill

    Add comment
    10|10000 characters needed characters exceeded