%percentage

[former_member205064]

Hi Experts,

How to get percentage value for the same row in webi

in Webi:-

-thanks

[Former Member · Accepted solution]

Hi raunak,

Create a variable to get the Sales revenue of California

=[Sales revenue] Where ([State]="California")

and create one more variable to get the percentage

=[Sales revenue]/[CaliforniaSalesRevenue] In ([Year])

[Former Member]

Hello Raunak,

Right click on the Sales revenue Measure-->Insert and click Percentage.

regards

Niraj

[former_member205064]

Hi Niraj,

That is wrong value.

The value for Colorado should be:-

[SalesRevenue] for Colorado /[SalesRevenue] for California.

For DC

[SalesRevenue] for DC /[SalesRevenue] for California.

Like wise and for 2005 year

[Former Member]

Hello Raunak,

Your question was not clear on that part. I assumed that you needed just the % anyways its good you got the solution.

Regards

Niraj