Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! How to make a table?
in the cell of month to display another month sales.
The user selects the reporting months (2015-02 and 2015-03) and the base month (X, e.g. 2015-01). It is necessary to compare the values. (3 dimensions: Region, Store, Year-Month)
load * Inline [
Region, Store, Year-Month, Sales
Region 1, Store 1, 2015-01, 111
Region 1, Store 1, 2015-02, 222
Region 1, Store 1, 2015-03, 333
Region 1, Store 2, 2015-01, 444
Region 1, Store 2, 2015-02, 555
Region 1, Store 2, 2015-03, 666
Region 2, Store 3, 2015-01, 777
Region 2, Store 3, 2015-02, 888
Region 2, Store 3, 2015-03, 999
Region 2, Store 4, 2015-01, 1111
Region 2, Store 4, 2015-02, 2222
Region 2, Store 4, 2015-03, 3333
];
Maybe like attached?
Maybe like attached?
swuehl, Thank you very much!