Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All
I need to show % of Total,i mean if suppose my data is like this(thinking to show either in straight table or pviot table)
rawmaterialname suppiler no.of lots
hydrogensulphate birla 10
hydrogensulphate l&t 20
hydrogensulphate hzl 30
sulphate birla 30
sulphate kun 50
sulphate nav 60
now,In my straight table or pivot table i need a column with %of total
dimensions :rawmaterial,suppiler
Table:
rawmaterialname suppiler %of total
hydrogensulphate birla i need some thing like this(10/60)
hydrogensulphate l&t 20/60
.
.
sulphate birla 30/140
sulphate kun 50/140
so please help me with expression what should i need to write down in that column....will be any change whether i display it either in straight table or pivot table
thanks
naveen
Hi Sunny,
Apologies for your expression I was mistaken but mean while can you test mine also, I was able to achieve in this way also.
thanks
Kiran Kumar
Kiran -
No apologies needed my friend. With regards to the expression, there might be multiple ways to achieve your goals. Personally I try to avoid Aggr() function as much as I can. So I suggested the expression with the TOTAL qualifier .
Sure,
Just curious to know in the expressions
Sum(Total <rawmaterialname> nooflots) and Sum(Total {<rawmaterialname>} nooflots)
second uses set analysis and it is giving a different result, can you explain the first one a little bit more, like is it used for this kind of situations or elsewhere.
Thanks
Kiran Kumar
For sure:
First one is telling which field you would want to use the Total Qualifier on. Let's take the above example
First do a total by rawmaterialname
1) Sum(TOTAL <rawmaterialname> [no.of lots])
Now lets try by supplier
2) Sum(TOTAL <suppiler> [no.of lots])
Finally the overall total
3) Sum(TOTAL [no.of lots])
Crystal Clear .
Many thanks
Kiran Kumar
Awesome
Hello Byron
unfortunately see that TOTAL MODE option its graded out,i mean its not letting me to select any option of that particular expression ,please have u got any idea how to get away from this grand Total only for this particular column
thank you
naveen
Hello sunny ,
Thanks for your quick response but sunny wats the grand total we might expect when both the subtotal are showing 100% as far as i think the grand total has to be 100% am i right ,in my case i am getting all subtotal perfect i mean 100% but the grans total is showing about 94% and i am literally not able to expalin to my client when he ask me about that grand total,i tried to get rid of that grand total to the particular column by going in to expression tab------>no total but unfortunately the NO TOTAL check box is graded out i mean its not letting me to check any option ...so sunny is there any solution for this please
thanks
naveen
HI Naveen,
That Total Mode will be enabled for Straight Table, I think you are using Pivot table, that is why it is disabled.
Can you attach your expected output so that it is easier to understand.
Regards,
Jagan.
Perhaps have you some "no.of lots" without rawmaterialname associated