The following calculated field formula ([Sessions conducted at Top 5 clients]) generates a table of Sessions conducted at Top 5 clients
=TOPN(5,SUMMARIZE(Feedback,Feedback[Organised by],"Count of sessions",[Sessions conducted]),[Sessions conducted],0)
This table generates the correct result (I have verified the result by referring to this table in a SUMX() function). So far so good.
[Sessions conducted] is a calculated column computed as follows:
Can the TOPN() function be tweaked to generate a third column which will show a running total.
Here is a simple example
Suppose the TOPN() function above generates a two column table as follows:
How can I tweak the TOPN function to generate the following three column table
A 5 5
B 4 9
C 3 12
D 2 14
E 1 15
Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?