Skip to Content
avatar image
Former Member

Break/Section with Custom Grouping

I need a WebI report with grouping on Products and wanted different products as a group ,totals for each group In addition to row totals & percentage (see attachment)., from Product A- E as a color shade with Totals, F-H as other, & I- K as color shade. How would I get this done?

2.png (276.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 30, 2016 at 12:55 PM

    Hallo Christina

    You could create a variable to group them, example:

    =If([Product] InList("Product A";"Product B";"Product C";"Product D")) Then "Group 1" ElseIf([Product] InList("Product E";"Product F")) Then "Group 2" Else "Group 3"

    And then you could change the coloring according to the group variable

    Regards

    Antonette

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      You are example says you want to divide each row total with grand total i.e 1500/16...

      where as your formula says you want to divide group total by grand total..

      For fist scenario use =Sum([Sales revenue] )/Sum([Sales revenue] In Block )

      For second scenario you can use =Sum([Sales revenue] In ([Group]))/Sum([Sales revenue] In Block )

  • avatar image
    Former Member
    Mar 30, 2016 at 12:50 PM

    Hello Cristina,

    You need to make use of Conditional format based on percentage.

    Below tutorial should be able to help you in creating conditional rules.

    Web Intelligence 4.0: Conditionally format data based on defined thresholds

    Please note you can access this feature through Java/applet mode only.

    Regards

    Niraj

    Add comment
    10|10000 characters needed characters exceeded