Level 200, Module 204: Row Totals disappearing after all the selectors are applied

Shailesh
Shailesh Customer
Level 200: Building A Planning Solution in Board First Comment
in Academy

After applying all the selectors as attached, the values in row total disappear. Up until the second last selector, the row total values are present. Also Note, the individual rows and column values match with the expected output. Please help.

Selectors:

image.png

Expected Output:

image.png

My Output:

image.png

Answers

  • Brian Walker
    Brian Walker Employee
    10 Comments 5 Answers Level 300: Expanding Board in Your Organization Board Developer

    Hi Shallesh,

    My Name is Brian Walker.

    In order to resolve the issue, please check all the steps you have performed in lesson 6- Build the sales Data Model. Below are some steps you can focus on.

    Units Data View configuration 

    • 1-Use the "TEMP - ACT - DR – Units" cube for "data block: a".
    • 2-Set BY ROW to be by "store" and "product".
    • 3-Set BY COLUMN to be by "month".
    • 4-IN AXIS SETTINGS, remove the select on "show all" by column
    • 5-Select "SAVE".
      6-In DATA VIEW in the MULTIPLE ENTITIES BY ROW panel, set "flatten groups level" to "store".
  • Shailesh
    Shailesh Customer
    Level 200: Building A Planning Solution in Board First Comment

    Above mentioned steps are followed:

    image.png
    image.png

    Please note that, only after all the selectors are applied, the row total values show no values. As seen below, i have excluded one selector and it shows value.

    image.png

    Thankyou for your help

  • Brian Walker
    Brian Walker Employee
    10 Comments 5 Answers Level 300: Expanding Board in Your Organization Board Developer

    Hi Shailesh,

    Can you share the screenshot of the "TEMP - ACT - DR – Units" Cube structure?

  • Shailesh
    Shailesh Customer
    Level 200: Building A Planning Solution in Board First Comment

    Hi Brian,

    PFA:

    image.png

Categories