Attachment 36451
Hi,
I have the above report using a Crosstab Query that puls data from multiple tables.
My question is, can I do a calcualtion based in the report based on the data?
What you under Mon, Tue etc. is the Flag_ID's for a driver performance. e.g.
Flag_ID
1 = Y/Y
2 = N/Y
3 = N/N
and All the Metric_IDS's (1-11) have different weightages. e.g.
Metric_ID's
1 = 5
2 = 10
3 = 15
And all these (1-11) weights dd up to a total of 100.
I want to do a Sum IIF with weights under each day based on the Metric_ID's and the Flag_IDs'.
Any help is appreciated.