Forum Discussion
Column in table calculated by filter on view
Hello everyone,
| Solutions | Regions | Year |
| Solution 1, Solution 2, Solution 3 | Region 1 | 2022 |
| Solution 1, Solution 2 | Region 2 | 2023 |
| Solution 3, Solution 2 | Region 3 | 2022 |
| Solution 1, Solution 4 | Region 1 | 2023 |
I would like to see if there is a possibility to do the following:
I would like to have an additional table with just the Solutions and counter on how many times certain Solution X appears.
However i would like to have multiple several dashboards, where I can filter Years or Region, and by filtering those I will get different values, like for example:
| Solution | Number |
| Solution 1 | x |
| Solution 2 | y |
| Solution 3 | z |
| Solution 4 | u |
x,y,z,u - are the number of appearances of Solutions in Column Solution based on the filter you use.
View 1: I filter on the page Region 1, and then i can plot Bar Chart that is going to show me in Region 1 count of Solution 1/2/3/4.
View 2: I filter on the page Year 2023, and i can plot Bar Chart that is showing me only for Year 2023 representation of how much Solution 1/2/3/4 appeared.
However i am aware that this is hard to implement as multiple filters on multiple pages can make a mess in column. I would like to hear your ideas and suggestions. I know that i can create new columns for each filter option, but since i have multiple Years and multiple Regions, this would mean that i need to make many different columns.
Thank you for your advices in advance.
BR.
Using Power Query, I would split the Solutions column into rows:
Then trim the leading space in Solutions and you'll have data that is easier to use:
3 Replies
Using Power Query, I would split the Solutions column into rows:
Then trim the leading space in Solutions and you'll have data that is easier to use:
Seems like an great idea. However would it be possible to split column into rows but in another Table as i want data in this table to stay the same.
Sure, you can create a second table in Power Query. Right-click the query and select "Reference", and the new query will point to the original query. Apply the steps above to the new query.
