Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Create Quarter Sales for current year and compare with Previous Quarter in Cross Table


Sony Hejmady

Recommended Posts

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

×
×
  • Create New...