My Requirement is like below in crosstab.
name total product name
top 100 count based on product type....
Thanks & Regards
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
9 replies Latest Post - 2013-02-01T16:57:41Z by SystemAdmin
Pinned topic rank in crosstab with two dataitems
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-01T16:57:41Z at 2013-02-01T16:57:41Z by SystemAdmin
Re: rank in crosstab with two dataitems2013-02-01T14:08:49Z in response to coolcognosHave a look at the attached 10.1.1 example which goes against the Go Sales(query) relational package. It cheats a bit by using the OLAP filter function on the edge of the crosstab but it gets the job done.
filter([Sales (query)].[Product].[Product type],rank([Quantity])>10)
If this is not what you are looking for, please put together a samples crosstab which further explains your requirement.
AttachmentsUpdated on 2014-03-25T07:43:19Z at 2014-03-25T07:43:19Z by iron-man
SystemAdmin 110000D4XK15496 PostsACCEPTED ANSWER
Re: rank in crosstab with two dataitems2013-02-01T14:56:24Z in response to DanielWagemannHi Daniel,
I have quick question relate it to this query. Since we are dealing with relational data I thought we can't use OLAP function such as "Filter" or mix OLAP function with relational function. I am bit confuse.
Re: rank in crosstab with two dataitems2013-02-01T16:39:03Z in response to SystemAdminThat is the part that cheats... a crosstab spins a cube object behind the scenes which may allow you to use certain OLAP items. Just like when you click on a measure and hit summary ... it creates an OLAP style total even though its a relational data source.