I create dashboard with 3 sheets. First is data table, in other are sums, counts and percent values resulting from the first table. Calculation in summary tables i made in topic.
Now i need change summary tables by adding additional division by segments. Calculation in topic have some disadvantages i can't scroll down and is a limit of text. I need to count about 30 indicators.Through these disadvantages, I did it in two sheets.
Do any of you have an idea how to do it differently and replace sum sheets for one table. Looking like the one below. I would add that it is an action that narrows the sum to the selected