Dear all , how to do split rows by group to columns of dynamic way ?
Input | Output | |||||
Type | Value | Profit | Cost | Revenue | ||
Profit | 10 |
| 10 | 40 | 100 | |
Profit | 20 | 20 | 20 | 400 | ||
Profit | 30 | 30 | 30 | 200 | ||
Profit | 20 | 20 | 10 | 300 | ||
Cost | 40 | 30 | 400 | |||
Cost | 20 | |||||
Cost | 30 | |||||
Cost | 10 | |||||
Cost | 30 | |||||
Revenue | 100 | |||||
Revenue | 400 | |||||
Revenue | 200 | |||||
Revenue | 300 | |||||
Revenue | 400 |
Solved! Go to Solution.
@flying008, the simplest way would be using a tile tool along with a cross tab, this will work dynamically.
I hope this helps!
Thanks!