Which Chart suits this format??

[harleen_singh]

Hello,

        Which chart or table in Qlikview supports Following type of Format??

	Jul-06			Aug-06			Sep-06
Order Type	Sales	Cost	Margin	Sales	Cost	Margin	Sales	Cost	Margin
Direct	$489,329	$491,706	($2,377)	$1,538,408	$1,512,155	$26,254	$1,165,897	$1,140,006	$25,891
Online	$473,388	$283,524	$189,864	$506,192	$303,496	$202,696	$473,943	$286,630	$187,313
Total	$962,717	$775,230	$187,487	$2,044,600	$1,815,651	$228,949	$1,639,840	$1,426,636	$213,204

thanks

Lavi

[#2 · Accepted solution]

Hi ,

   Pivot table will best for this.Add your time dimension and drag into top.

-Jai

[rajtechnocraft]

Hi I agree with Prakash, Pivot Table object will be best suited for these kinds of traditional reports. For your sample report you could follow the below steps Step 1: Create a pivot table object with dimension order type and Month Year Step 2 : Cretae concatenated dimension Month & '-' & Year as MonthYear . Step 3: Drag this MonthYear dimension to top row of the pivot table Step 4: Go to Presentation tab and use radiobutton partial sum for the dimension on which you want sub total and grand total .In your case it will be Order Type and MonthYear. Step 5: Use the report formatting options in Layout and style and complete your pivot report. Hope this procedure helps you to build your desired pivot report. Regards Raj.