Straight table aggregation

[venkatg6759]

Hi Please go through the attached qvw and help me how can i get the table like this

Firm       Name              api                    Weighted                

1                 X                 ask_broker         41.09%

Just one line for the desired selection made  and also remove the N/A values and show the single line  that is total .

[venkatg6759]

can anyone help me on this

[MayilVahanan]

Hi

Can you provide a sample file?

[venkatg6759]

check the attachment need to get the total of weighted% based on selected field.Thanks in advance

[Josh_Good]

Maybe I'm not understanding your question but this works as you described.

[venkatg6759]

i need to get the total of % weighted for the field.But i am gettting like this .

no name        field    weighted%

                                   4%

11  tradelink  security   2%

11  trade link  securtiy    2%.

But i need only one line like this

11  tradelink   security    4%

Thanks ,

[Josh_Good]

I believe that is what I am showing in the QVW.  What is wrong with my solution?

[Anonymous]

Why don't you use a Pivot Table ?

[venkatg6759]

According to your qvw weighted % is loaded inline but here i am having set analysis expression for that .

Thanks

[venkatg6759]

I tried using pivot table but unable to get weighted% in that table .i used the same expression but weighted% was not working .