Two total columns (diff, percent) horizontal as pivot / straight table layout

[#1]

Hello QVer,
our users need to have a pivot / straight table with two calculated totals (difference, percent) in two columns.
According to
http://community.qlik.com/forums/t/29136.aspx
it should look like
Year 2007 2008 Diff Percent
Budget 1100 1500 +400 xx%
Sales 1000 900 -200 yy%

I constructed a table but I failed matching Diff and Percent side by side - see attached example.
Does anybody has an idea for such layout - diagram or script?
Thanks.

[deepakk]

hi,

Check out the Attachment. i hope this helps you out.

[#3]

Hi,
thanks Deepak.
Would be nice but there are two challenges because there should be more than one fact data one below the other.

Can You solve it using Your suggestion?

[deepakk · Accepted solution]

hi,

YOu can acheive this with same example i have provided. I would like to how your identifying the Actual and Budget.

For eg : if both are coming same table. you have identify which row data is for sales and which one for budget and create a field.

If (type =..... , Sales , Budget) as Type.

eg2 : if you data is coming from two different tables...

then combine bodth the table to one..

Make sure you value field and date/year fields are same. also create a dummy field in both

'Sales' as type

'Budget' as type.

Once this is done.just add the TYpe field in dimension. YOu will get the required output.!!!