How to create an expression to calculate the Vertical Analysis

[#1]

In this attachment “example.qvw”, what I should do to make the category “B” the reference of the expression “VA” and make the correct calculation in percentage? The result should be exactly as the attachment “example.xlsx”.

[#2 · Accepted solution]

Check the uploaded doc

[fernando_tonial]

Hi, you can try this.

Value / Top(Value,2)

OR

Value / Sum({$<category={'B'}>} total<business> value)

Best Regards.

Tonial.

[Anonymous]

This expression works:

(value) / sum({$<category={'B'}>} total<business> value)

[#5]

Attached with answer.

Thanks

AJ

[mehmet_caldak]

Hi,

Try Below function as i did in the attached example.

[#7]

It works!!!!

Thanks...

Best Regards.

Permirio.