Hi All,
I am building this report using just few dimensions and having troubles already
Dimension called “Customer Name” has various customers inside “e.g. Customer A, B, C… and so on” I also have a measure "Total ($).
I am able to display this infomation under same report under the same tab. Is it possible for me to display by customers in a different tab?
i.e. Customer A in tab 1, Customer B in a separate tab 2 and so on.
Thanks for your help in advance
regards
James[/b]
Jamesy121 (BOB member since 2009-05-04)
Hi James, and welcome to B:mrgreen:B
I think adding a filter to every tab, selecting in each a different customer, will do the trick for you.
Click on the Show/Hide Filter Pane button (on the lefthand side of Webi’s reporting toolbar. then drag the Customers object from the object list into the filter pane, and define a value for the filter.
Repeat this for every tab.
There’s no automatic way of doing this (that I know of), so if you have 200 customers or so, you may want to consider alternatives to this solution, for the sake of your sanity.
Might I suggest breaking the report into sections based on the customer?
-Ethan
ethan1701 (BOB member since 2004-05-05)
Hi James,
Your requirement may not be possible using Webi. But this can be achieved using Deski with some VBA code.
Here is the link https://bobj-board.org/t/61802
Hope this will help you.
Thanks
-Satish
forgotUN (BOB member since 2006-12-13)