Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working on an application in which I would like to present some data in a cross chart with two dimensions and one expression, where one dimension should be horizontal and the other vertical. Like this:
Category/Year month | 201201 | 201202 | 201203 | 201204 | 201205 |
A | 5000 | 6000 | 5634 | 5342 | 2754 |
B | 1234 | 6134 | 3245 | 234 | 6352 |
C | 5401 | 5340 | 765 | 6453 | 17753 |
D | 3421 | 654 | 256 | 2345 | 632 |
E | 5643 | 1345 | 23452 | 1234 | 5322 |
In this example, "Category" (whose values are going down) and "Year month" (whose values are going to the right) are the dimensions.
Is this possible to accomplish?
Thank you
I'm sorry, I found the answer through the "More Like This" box as soon as I had posted. Apparently the search queries I tried wasn't good enough.
The answer is to use a pivot table, and drag and drop the dimension to the top. Really smart.