Calculation of Sum based on filter selection

[Rajesh31]

Hi Someone Please help !!

Sample dataset 

CustID	Report month	2 wheeler sales	4 wheeler sales	cycle sales
1	4	120	40	3000
2	4	30	600	125
3	6	40	14	780
4	6	70	550	800
5	5	80	70	90
6	4	90	45	110

Iam trying to build a barchart and based on filter the measure should change , if i select 2 wheeler , i need the measure to be sum(2 wheeler sales), if I select 4 wheeler the filter should be sum(4 wheeler) , on top of this I want a MTD and YTD filter need to be applied ,Kindly guide me with the possible solution 

@peterbergman @JordyWegman @MayilVahanan @Mark_Little @David_Friend @vinieme12 

[MayilVahanan]

Hi

Change the columns to rows with help of cross table like below

CrossTable(SalesCat, Sales, 2)
LOAD * INLINE [
CustID, Report month, 2 wheeler sales, 4 wheeler sales, cycle sales
1, 4, 120, 40, 3000
2, 4, 30, 600, 125
3, 6, 40, 14, 780
4, 6, 70, 550, 800
5, 5, 80, 70, 90
6, 4, 90, 45, 110
];

For YTD, MTD, refer below link

YTQ, QTD, MTD and WTD - Qlik Community - 1489245