LEVEL 1 MODEL BUILDING : PART 12 DASHBOARDS

Svint Park
Svint Park
in Modeling

I am on Part 12 Activities : Create Saved Views.

On Create Saved Views for REP02 module,

I was trying to make a new view for REP02: Chart DB just as guide shown below.

 

Saved View Name: REP02: Chart DB

Filter: n/a

Pages: G2 Country, Line Items

Columns: Time

Rows: n/a

 

I am having a problem with item 'Size'.

If I go to Blueprint Mode and modify 'Applies To' to remove Size, I get this warning message.

 

MSG : Datatype mapping used for aggregation doesn't match any dimension of the result

 

How do I remove Size?

Tagged:

Best Answer

  • Misbah
    Misbah
    Answer ✓

    @Svint Park 

     

    It will not allow you to remove the Size List because it is aggregating the values based on Size list. See first two line items

     

    Revenue  ----Source[SUM: Size]

    Cost of Sales----Source[SUM:Size]

     

    If you remove the formula from these line items it will allow you to remove the Size list from the module. However I am not going into details why do you want to remove it 

     

    Happy Planning

    Misbah

Categories