Totals for Columns

[mwood]

Hello All,

I am in the process of completing Level 1 training for Anaplan. I have finished all the exercise. however there is one exercise I was not able to complete. that is set up a UX view for Rev02 Volume inputs as required under the exercise. the View has been created but I am not able to get totals for the columns (monthly totals). I tried almost everything. Under Data > Totals Positions>After.

please let me know what options should i look at to resolve this. 

thanks

Screen Shot attached

[shyam_kumar]

Hi mwood, 

You have to add top level to the list which is used in row dimension and select sum as summary for line item Volume.

Regards,

Shyam Kumar  

[bhatjaved]

@shyam_kumar 

Have you made P2 products as hierarchical list parented by P1 ?

It should be P3 parented by P2 and P2 parented by P1 , it will result you data in the fashion you want in your view .

[mwood]

Hi @bhatjaved 

Here are the screenshots ,there is no P3 in the example in LV 1 

this is P2 rolled up to P1

P1 rolled up to P2

or am i missing something ?

[bhatjaved]

@mwood 

No you are good P3 hierarchy build will be your exam exam activity once you start doing exam activities 

Coming back to your question can you show me blueprint view of your module ?

[mwood]

Hi,

please find below blue print view of the UX page i am trying to get help on

[mwood]

hi Shyam,

please check the screenshot, 

P1 product family has all products as top level item

and P2 has p1 product family name in parent hierarchy

i hope this is what you were referring too

thanks.

[shyam_kumar]

Hi @mwood ,

Please make sure your P1 and P2 hierarchy looks like below screenshot: 

P1: 

 

P2: 

And if p1 and p2 hierarchy does not match the above screen shot you might have to fix your import action which creates these hierarchy. If p1 and p2 hierarchy does match above screenshot. please make sure you have not selected few items to show. Finally your REV02 module should look like this below screenshot: 

 Regards,

Shyam Kumar

[mwood]

Hi Shyam,

I am getting all those views as listed by you. My issue is when I want to look only at the forecast period and within that for a particular city. i am not getting the subtotals the month.

regards,

Malcolm

[shyam_kumar]

Hi @mwood ,

Could you please share what filter you have applied in the view and logic behind it?

Regards,

Shyam Kumar