Welcome Guest [Log In] [Register]
Add Reply
CrossTab to act like Pivot Table
Topic Started: Jan 27 2018, 08:53 AM (4 Views)
LarryWalker

Hello,

I'm hoping someone here can help. I have a user who is trying to create a cross tab - basically have it work like a pivot table in excel.

I have 3 screen shots attached. The first is the data in a table format. The second is the data in the cross tab format. And the third is the data in an excel pivot table.

Basically the user wants the webi report's cross tab to have the data displayed as the excel pivot table.

As you can see in the cross tab screen shot, the amounts are just repeated for each province - the pivot table screen shot shows how it should look. Is there a way to get the cross tab to look like the pivot table?


I didn't find the right solution from the internet.
References:

http://www.forumtopics.com/busobj/viewtopic.php?t=213328&sid=395faf5987b23b83cb09c15521a54bc2

Recycle management system video
Offline Profile Quote Post Goto Top
 
1 user reading this topic (1 Guest and 0 Anonymous)
« Previous Topic · Chatboard · Next Topic »
Add Reply

Free Domain Name