cancel
Showing results for 
Search instead for 
Did you mean: 

webi

Former Member
0 Kudos

Hi,

in my webi report  having 3 classes

that is

produt <class

1)productnanme,

2)productid,

time<class

1)year

2)quater

3) month

4)week

sales< class

1) revenues

2) sales order

but my report show like tis

productid, revenueof jan, revenue of feb,.........................................upto revenue of dec

How to do report like above

Accepted Solutions (1)

Accepted Solutions (1)

nscheaffer
Active Contributor
0 Kudos

If you want the revenue for each month to go across your report horizontally it sounds like you need to use a crosstab.

Check out this link and scroll down to "Working with Tables and Crosstabs" for some information on how to use crosstabs...

Noel

Answers (1)

Answers (1)

former_member59613
Contributor
0 Kudos

Totally agree with Noel.  This is definitely a candidate for a Crosstab report.

Here's an interesting youtube video on how to use crosstabs and some other webi features:

https://www.youtube.com/watch?v=_Q4riQum72o

Thanks

Jb