My Requirement is like below in crosstab.
name total product name
top 100 count based on product type....
Thanks & Regards
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:49ZThis is the accepted answer. This is the accepted answer.
- coolcognos 270003T004
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 Posts
Re: rank in crosstab with two dataitems2013-02-01T14:56:24ZThis is the accepted answer. This is the accepted answer.
- DanielWagemann 2700058MAJ
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:03ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK