Forum Discussion
How to dynamically total/count across multiple columns of a dynamic array
Hi, I'm trying to create a dynamic column that will give me a count based on two columns of a dynamic array. So if I've got three products across four offices like this... I want to sh...
Yes indeed many options!
I’m really using this as an excuse to get better with dynamic arrays so if I can learn to build this as a one formula table, that would be great.
I’d rather avoid pivot tables as I find them inflexible if you’re trying to use the output for another process.
The output for this will eventually populate a csv for a journal import.
Great responses - I’ll spend some time digesting and learning some of the functions I haven’t used yet.
I’m really using this as an excuse to get better with dynamic arrays so if I can learn to build this as a one formula table, that would be great.
I’d rather avoid pivot tables as I find them inflexible if you’re trying to use the output for another process.
The output for this will eventually populate a csv for a journal import.
Great responses - I’ll spend some time digesting and learning some of the functions I haven’t used yet.
IMHO, spill, PivotTable in tabular form and structured table returned by Power Query will give exactly the same csv output. From that point of view no difference.