QV11 SR11 - Pivot table - show data which is not in dimension

[vtatarnikov]

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

];

[swuehl · Accepted solution]

Maybe like attached?

[vtatarnikov]

swuehl, Thank you very much!