Hello
I am new to ReportPlus. I am able to create a report connecting to SSAS.
How do i get the top 25 rows based on value column?
Rows: Product
Column: Month
Values: Count of product sold
I want to display top 25 products based on sales in a month? What steps do i need to follow to accomplish this report?
Thanks
S
Siva,
Thanks for the update!
Regards!
Verified and found that the feature 'Top 25 Products' is working. Thank you for your support.
Hi again!
We were trying to reproduce the issue, but we weren't able to.
We wanted to ask you more specific information.
Could you contactme to cpla at infragistics.com?
Best!
Hello,
I tried the above and the data is not being displayed for Top 10 items.
Query:
I verified the MDX query. This is what Report+ in the "Query" window
select NON EMPTY hierarchize([Current Transaction Month]) on columns,
NON EMPTY TOPCOUNT([Product].[Product].children, 25, [Measures].[Product Count]) on Rows from (select [Store].[Store].&[1234] on columns from [MyCube]) where [Measures].[Product Count]
This is the query i wrote to get the data in SSMS.
select {[Measures].[Product Count]}on columns,{TOPcount( [Product].[Product].children, 25, [Measures].[Product Count])
} on rowsfrom [MyCube]where ([Current Transaction Month], [Store].[Store].&[1234])
Anyone is having an issue like this?
Hi!
In this scenario you should add a numeric filter to the pivot table.Assuming that you have the descripted pivot table, try this:1. Tap your “Product” dimension 2. Tap Filter by Rule, by default it shows “Top 10 Items”3. Tap the “Top 10 Items” filter4. You should see that “Numeric” filter is selected, and at the bottom you should see the amount of rows for the “top” filter.
I hope this could help you!