I have column count effort on it based on formula,i would like to show the result per months so i created new page and add view from this table, how i can show the effort only for the page month.
so how can i change the column formula inside view with out update the formula of origin table?
You can’t have different formulas on the same column in different views.
Instead duplicate the column, and change the formula on the duplicate.
Then you can hide the new column in view A, and hide the old column in view B.
Thanks for your Answer,
your suggestion is very good but in my case unfortunately will not work, cause I have other tables read this column in statistics.
Even if it’s hidden, other tables can still read the column
Another option is to use Countif() and only count for the specific month. You can also use a select control as a variable.
And another option is to group on the month, and summarise the column using ount.
Or you could filter the column, and count the results.
thanks, I will try CountIf and see if its work for me )
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.