% of Row or Col total

[pradeepall4u]

Hi,

I am trying to create a clustered col chart which shows the % of tickets created by weekday by location.

Actual Values
Tickets	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Grand Total
GT	1	21	68	162	172	190	74	688
HN	123	212	557	1206	1615	1568	1505	6786
IND	346	430	591	761	1058	1451	1863	6500
US	78	180	353	557	814	963	1020	3965
Grand Total	548	843	1569	2686	3659	4172	4462	17939
Calculated Values
Site	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Grand Total
GT	0%	3%	10%	24%	25%	28%	11%	100%
HN	2%	3%	8%	18%	24%	23%	22%	100%
IND	5%	7%	9%	12%	16%	22%	29%	100%
US	2%	5%	9%	14%	21%	24%	26%	100%
Grand Total	3%	5%	9%	15%	20%	23%	25%	100%

Desired Output:

Desired Output

Thanks and regards,

Pradeep

[Anonymous]

[Value % of Time] =
var __currentValue = [Measure]
var __totalValueAcrossTime =
	calculate(
		[Measure],
		allselected( 'Calendar' )
	)
var __percent =
	divide( __currentValue, __totalValueAcrossTime )
return
	__percent