Sony Hejmady Posted September 4, 2020 Share Posted September 4, 2020 Hi, I need to calculate Previous Quartre Sales as seen below for Previous Quarter in Cross table expressions with group by Comp and Section. Please help as this expresion I need to setup in Crosstable Comp section Date Quarter Sales Previous Quarter Sales 10 111 2-Feb-20 Q1 114 10 123 2-Feb-20 Q1 11411 10 134 2-Feb-20 Q1 1142 10 145 2-Feb-20 Q1 1142 12 345 4-Apr-20 Q2 455 13809 12 785 4-May-20 Q2 33444 13809 12 323 4-May-20 Q2 333 13809 12 234 6-May-20 Q2 56666 13809 13 348 7-Jul-20 Q3 333 90898 13 908 4-Jul-20 Q3 443 90898 13 678 9-Jul-20 Q3 33333 90898 13 325 30-Aug-20 Q3 5433 90898 Link to comment Share on other sites More sharing options...
Sony Hejmady Posted September 8, 2020 Author Share Posted September 8, 2020 Does anyone can help here please Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now