Skip to Content
0

Convert rows to columns?

Nov 17, 2017 at 02:53 PM

23

avatar image
Former Member

I have a requirement which looks like below ::

I want to display cost for today's date and previous date and then display their difference..

for ex -

prod_name cost_today cost_yesterday cost_difference

XYZ $1 $2 -$1

Problem - when I am fetching the cost for 2 days it is coming i the row format rathr than column.Like :

prod_name cost

XYZ $1

XYZ $2

How to attain the feature I need in Boxi.. Please help!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Nov 17, 2017 at 02:53 PM
0

try with cross tab in webi

Share
10 |10000 characters needed characters left characters exceeded