percentage in straight table

[arulsettu]

hi

i am having three years sale in straight table

like 2003 2004 2005

now i need show the percentage ho can i do that?

[nizamsha]

can u provide ur sample qvw so others can do if for u

[arulsettu]

here is the app

[alexandros17]

... the example

[arulsettu]

hi Alexandros17

using personal edition so cant open sorry for the inconvenience

[alexandros17 · Accepted solution]

Write this expression in the column %:

sum({<Year={$(=max(Year))}>}Cheque)

/

sum({<Year={$(=max(Year)-1)}>}Cheque)

[nizamsha]

PFA

[nizamsha]

=(sum({$<Year={"$(=Max(Year))"}>}Cheque)-

sum({$<Year={"$(=Max(Year)-1)"}>}Cheque))/

sum({$<Year={"$(=Max(Year))"}>}Cheque)

in number format fixed to decimal 2 and check the show in percentage

[arulsettu]

thanks all