AnsweredAssumed Answered

How to transpose records at report form?

Question asked by egbaumier on Jun 5, 2014
Latest reply on Jun 6, 2014 by erolst

I'd like to get suggestions how to show at report form this information:

 

At form I have

 

Record Value Date

Rec1 100 1/1/14

Rec1 120 2/1/14

Rec1 150 3/1/14

Rec2 100 1/1/14

Rec2 100 2/1/14

Rec2 130 3/1/14

SubTotal 700

 

I really need to show at this view

 

Account Jan Feb Mar Q1

Rec1 100 120 150 370

Rec2 100 100 130 330

SubTotal 200 220 280 700

 

Any suggestion how to do it? At spreadsheet is easy to show it.

 

Regards

 

Edison Garcia

Outcomes