Pivot table in webi

[system]

Hi There,

My client has given a requirement in Excel as Pivot table. How do I do this in webi.

Thanks

---

chazp (BOB member since 2015-03-04)

[MarkP]

Welcome to B B!

Create a crosstab/crosstable - have a look in the help guide to make sure you’re comfortable with it. Ideally get yourself on some training if you’re delivering things to clients; don’t want the tool to get a bad name just because you’re not familiar with it

Regards,
Mark

[system]

Thanks Mark. Will do.
Also on an additional note, use input controls, as these will work like a filter bar in webi

---

chazp (BOB member since 2015-03-04)

[system]

Also do you know how to calculate a time difference between 2 cells in the same column.
Thanks

---

chazp (BOB member since 2015-03-04)

[MarkP]

@chazp

Thanks Mark. Will do.
Also on an additional note, use input controls, as these will work like a filter bar in webi

Yes. Please, do some reading of the help, buy a book or get some training. SAP do some very good free materials to help you through a lot of the basics:
http://scn.sap.com/docs/DOC-7819

[system]

do you know how to calculate a time difference between 2 cells in the same column.

---

chazp (BOB member since 2015-03-04)

[MarkP]

This topic could help you:

Converrt HH:MM:SS into MM

Hello ALL, I have created a variable called average and used the below formula: =DaysBetween([On Location Time];[Dispatched Time]) * 86400 +(ToNumber(FormatDate([On Location Time];"HH")) * 3600 + ToNumber(Left(FormatDate([On Location Time];"mm:ss") ;2)) * 60 + ToNumber(FormatDate([On Location Time] ;"ss")))- (ToNumber(FormatDate([Dispatched Time] ;"HH")) * 3600 + ToNumber(Left(FormatDate([Dispatched Time];"mm:ss");2)) * 60 + ToNumber(FormatDate([Dispatched Time] ;"ss"))) Average: =FormatNu…

BOB has a great search feature - many of your questions have been covered before.

[MarkP]

In addition to that, you’ll need to understand the Previous and/or RelativeValue functions.