How to add avg column in straight table based on calculated expression

[savithri_n_s]

Hi,

I have attached the qvwfile. In sheet 5 i have straight table all the columns are calculated based on expression

Now how can i add average based on calculated expression for each row as FY18 Average

Can you please help?

US_GU_RES_OG - Metric Name	Sep-17	Nov-17	Oct-17	FY18 Average
Total Cx Labor Based Spend	$8,058,084	$5,651,602	$6,261,427	$7,318,280	$6,657,038
Total Cx Labor Based Spend (millions)	$8	$6	$6	$7	$7
Cx PSL Spend*	$4,947,535	$3,468,309	$3,968,075	$4,823,169	$4,127,973
Cx PSL Spend* (millions)	$5	$3	$4	$5	$4
% Cx PSL Spend	61%	61%	63%	66%	62%
# Unique PSL Suppliers	15	15	16	16	16
# of Active NA Cx Managed Contractors	456	475	468	436	466
# of Active Direct Sourcing Contractors **	29	26	25	25	27

[Digvijay_Singh]

I don't have access to view qvw but may be something like this works-

(Column(1) + Column(2) + Column(3))/3

[savithri_n_s]

Hi Singh,

Thanks

This is not helping me as I want the expression to be dynamic

Example this is the expression i have used for column

# of Active NA Cx Managed Contractors

count({<[Data Source]={'CX Managed','cx Managed'}, [Assignment State]= {'Effective','Effective-OnBoard'}>}[Data Source]) for Sep-17,Oct-17.,Dec-17, Jan-18 columns

And i need one more column next to that as Avg FY18

How can i change based in this expression only in column Avg FY18 and rest of the column should remain same.

[savithri_n_s]

Hi sunny talwar,

  I heared you are qlik expert

I see that too with your solutions.

Can you please me?