[TABLE="width: 500"]
<tbody>[TR]
[TD]act ytd (9mth)
[/TD]
[TD]Bgt ytd (mth)
[/TD]
[TD]variance
[/TD]
[TD]Total Budget full year
[/TD]
[TD]Balance Budget
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]11
[/TD]
[TD]-1
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hai
I want prepare a report on variance between YTD (example 9 month), so I will used slicer to compared actual vs budget. At the same time I want another column to show full year budget which I will from actual (9 month) I will get net balance budget
example
<tbody>[TR]
[TD]act ytd (9mth)
[/TD]
[TD]Bgt ytd (mth)
[/TD]
[TD]variance
[/TD]
[TD]Total Budget full year
[/TD]
[TD]Balance Budget
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]11
[/TD]
[TD]-1
[/TD]
[TD]20
[/TD]
[TD]10
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Hai
I want prepare a report on variance between YTD (example 9 month), so I will used slicer to compared actual vs budget. At the same time I want another column to show full year budget which I will from actual (9 month) I will get net balance budget
example