% of total

[kunkumnaveen]

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

[kkkumar82]

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

[sunny_talwar]

‌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   .

[kkkumar82]

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

[sunny_talwar]

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])

[kkkumar82]

Crystal Clear .

Many thanks

Kiran Kumar

[sunny_talwar]

Awesome

[kunkumnaveen]

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

[kunkumnaveen]

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

[jagan]

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.

[sfatoux72]

‌Perhaps have you some "no.of lots" without rawmaterialname  associated