Pivot table expressions

[#1]

Hi Qlikview Friends

I hava a data as fallows

	Jan	Feb	Mar	Apr	........	Dec
Count1	200	120	235	460	.........	301
Count2	150	112	183	340	......	209
Count3	120	130	139	120	....	127
YTD	470	362	557	920		637

Count1 = Count(Field)

Count2 = Count(Field)

Count3 = Count(Field)

with different conditions

YTD = Sum(Count1, Count2, Count3)

but I want as fallows

	Jan	Feb	Mar	Apr	........	Dec	YTD
Count1	200	120	235	460	.........	301	1316
Count2	150	112	183	340	......	209	994
Count3	120	130	139	120	....	127	636et

I can get this using partial ''sum option with Month'' but it always comes  'TOTAL' as Title , different colour, bold font etc

but I want just YTD as title same as other expressions

I tried  count1, count2.count2 expressions horizontally , YTD expression as vertically  but its not coming all expressions either coming vertically or horizontally .

can we make some expressions vertically and some expressions horizontally in pivot table please advice me

[chaper]

Use partial Sum and  change the label for TOTAL..See below

[chaper]

Also check this link.Pivot Table SubTotals when a Dimension determines Expression Calculation .Good example provided by stevedark‌ for customising Pivot table Totals

[#4]

Thanks You,

but is it doable , like some expressions as vertically , some as horizontally in single pivot table

Regards

NKummari

[chaper]

NO for Expressions.But YES for Dimensions

[chaper]

Check this it may help you how to get one expression horizontal and one vertical in pivot table?