WideSheet - Adding multiple dimensions
So I’ve gotten most of the multi dimensional support completed. I only really need to create a user interface for moving dimensions around within the same axis or to another dimension.
The following screencast demos it a bit. Click on the screen shot below to view it:
So what is actually happening here is that I am creating a spreadsheet for revenue for various sites of mine (The revenue figures in the screencast bear no resemblance to actual revenue).
- For the first part it is a normal 2 dimensional spreadsheet. I enter revenue per site per quarter
- I then add another dimension to it (Year)
- I Enter some data for the next year
- I add a further dimension, but this time to the Y axis. I call it revenue type.
- I add further data for the new revenue type
- I Create a new view to demonstrate another view of the same data
- I Pivot it, which basically flips the x and y axises.
My next demo will demonstrate the gui for moving dimensions around. The data model already supports it, but I’m working on as simple a gui as possible to do so. With this you should be able to change the order of dimensions, so you for example see the product dimension before the revenue type dimension. You could also move revenue type to the x axis instead.

Follow me on Twitter