Pivot Table

[vsharma1]

Can we display like below in Pivot Table?

		YTD 2018	YTD 2019	MTD 18	MTD 19
Textile	Revenue	5000	8000	500	700
Food	Revenue	2000	3000	200	250
Transport	Revenue	1000	2000	300	450

[Gysbert_Wassenaar]

Yes.

[vsharma1]

Sorry i cant open qvw 

Can you attach code in text file or word doc with screenshots if possible please thanks

[vsharma1]

Sorry i cannnot open qvw 

Can you attach code in text file or word doc with screenshots if possible please thanks

[vsharma1]

i cant open the qvw since i do not have the license version available

[Gysbert_Wassenaar]

Here's the load script:

SET ThousandSep='.';
SET DecimalSep=',';
SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimeFormat='h:mm:ss';
SET DateFormat='D-M-YYYY';
SET TimestampFormat='D-M-YYYY h:mm:ss[.fff]';
SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
SET DayNames='ma;di;wo;do;vr;za;zo';
SET LongMonthNames='januari;februari;maart;april;mei;juni;juli;augustus;september;oktober;november;december';
SET LongDayNames='maandag;dinsdag;woensdag;donderdag;vrijdag;zaterdag;zondag';
SET FirstWeekDay=0;
SET BrokenWeeks=0;
SET ReferenceDay=4;
SET FirstMonthOfYear=1;
SET CollationLocale='nl-NL';

LOAD * INLINE [
    Product, Type  , YTD 2018, YTD 2019, MTD 18, MTD 19
    Textile, Revenue, 5000, 8000, 500, 700
    Food, Revenue, 2000, 3000, 200, 250
    Transport, Revenue, 1000, 2000, 300, 450
];

Here's the screenshot:

The pivot table has two dimensions: Product and Type.

The pivot table has four expressions: Sum([YTD 2018]),Sum([YTD 2019]),Sum([MTD 18]) and Sum([MTD 19])

[vsharma1]

Thanks, I will try your solution  and let you know soon