Hello. I need to produce a column in Pwerplay which will count all rows in a report. I use the report to keep track of products, and I would like to know how many times a particular product is sold. Is there any way to keep a count of items in a report? I was thinking about creating a measure, but I'm not sure what kind of calculation to use. Any help would be much appreciated. Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Counting Rows in Powerplay
- Thread starter thabrane
- Start date
This would depend on how your data is fed into trandformer i.e. transactional data or summary data.
Either way you would need to bring a field into your transformer model showing the number of sales. If the data is transactional this would always be one.
You could then add a measure to your cube, to sum the number of sales.
HTH
Gary Parker
Systems Support Analyst
Manchester, England
Either way you would need to bring a field into your transformer model showing the number of sales. If the data is transactional this would always be one.
You could then add a measure to your cube, to sum the number of sales.
HTH
Gary Parker
Systems Support Analyst
Manchester, England
- Status
Similar threads
- Locked
- Question