1 Reply Latest reply on Apr 17, 2018 7:07 PM by swaroop.gantela

# Counting Rows From Another Sheet Calculation

Howdy all!

I am playing with an event where I have a worksheet with it's own table calculation and to have a count of the row results from that sheet appear beside it.

My issue is that simply applying filters and such is simple for a row count but when that one worksheet has a very particular table calculation, how do I grab those changes and calculate that on my worksheet that's just counting?

I attached a quick super-store dashboard in 10.5 as an example. As a bonus I am using the calculation:

RANK_PERCENTILE(WINDOW_AVG(sum([Sales]), 0 , 10))

I don't even know what that does in accordance to my table I slapped together lol. I saw it somewhere if someone could explain it. Reading the functions was a bit confusing for me in accordance to what I see it represent on the table.

Thanks for any assistance!

• ###### 1. Re: Counting Rows From Another Sheet Calculation

Jonathan,

The method described here is likely suboptimal in many ways,

but maybe it can give some ideas.

For more ideas, here are some other threads discussing this subject:

Pull summary info into title

How to display a count of the visible rows?

marks count | Drawing with Numbers

The first two discuss putting the count in the title.
I think it will be difficult to put it into another sheet using the DecileCalc filter as is.

One of the suboptimal ideas presented in sheet Random Table 2 of the workbook

attached in the Forum thread is the use of parameters instead of the DecileCalcFilter.

This requires a separate setting for min and for max.

Then the records can by counted by:

WINDOW_SUM(iif([Decile Calc Net Sales]<=[DecMax] AND [Decile Calc Net Sales]>=[DecMin],1,0))