Count Greyed Out Selections

[Anonymous]

Hello,

Please see the following graph. So the total sales actually incurred every week through W1 to W17, so in total there are 17 weeks. But for these particular items at these particular stores, the sales only incurred through W4 to W16, which is 13 weeks.

I'm using count(total distinct week) to get the # of WEEKS and it got 13, but the requirement was to get it as 17. How could I count W1, W2, W3 and W17 when they are greyed out?

[sunny_talwar · Accepted solution]

May be this

Count(TOTAL DISTINCT {<STORE>} week)

[Anonymous]

What is the {Store} used for? Can you interpret this? Thanks

[sunny_talwar]

STORE is used to ignore selection in the Store field

[tajmohamed30]

right clik on that sheet --->Go to trigger tab-->

add action on ActiveSheet-->click -->Add-->selection-->select in field

then put Filedname above and in search string write the values