Totals for Columns

mwood
New Contributor

Totals for Columns

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

 

12 REPLIES 12
shyam_kumar
New Contributor

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
Regular Contributor

@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
New Contributor

Hi @bhatjaved 

 

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

mwood_2-1641647468320.png

this is P2 rolled up to P1

mwood_1-1641647423395.png

P1 rolled up to P2

or am i missing something ?

 

bhatjaved
Regular Contributor

@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
New Contributor

Hi,

 

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

mwood_0-1641706733741.png

 

 

mwood
New Contributor

hi Shyam,

 

please check the screenshot, 

P1 product family has all products as top level item

mwood_0-1641647813807.png

 

and P2 has p1 product family name in parent hierarchy

mwood_1-1641647860962.png

i hope this is what you were referring too

 

thanks.

 

shyam_kumar
New Contributor

Hi @mwood ,

 

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

P1: 

shyam_kumar_0-1641704267489.png 

P2: 

shyam_kumar_1-1641704351021.png

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: 

shyam_kumar_2-1641704719987.png

 Regards,

Shyam Kumar

 

 

mwood
New Contributor

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
New Contributor

Hi @mwood ,

 

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

 

Regards,

Shyam Kumar