Compute running total via a calculated field formula

Question

Hi,

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:

=DISTINCTCOUNT(Feedback[Date])

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:

A 5
B 4
C 3
D 2
E 1

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

Please help.

---

Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com