Hello people.
I have a view (screenshot attached) that represents the items bought in a given period by different departments within the organization.
The departments (DeptName) and items (ItemRef) can therefore have repetitions.
What i would like to achieve is a crosstab (i think that's where i need to go) where:
-I have one item per line
-A department "group" with a quantity (Qty) and unit price (Valor Unitario) columns, with a total of [Valor Unitário]*[qty] by department,
like the screenshot "report". I am having problems creating this report because when i hit the crosstab wizard, i end up with a report like the "report_preview" image. I dont want to aggregate the [Qty] and [Valor Unitario] but i have to or the report wont build.
What am trying to achieve is similar to the demo "Product Sales per Period" , is there any step by step other than the video, which i cannot watch or download because flv's are blocked here?
I have a view (screenshot attached) that represents the items bought in a given period by different departments within the organization.
The departments (DeptName) and items (ItemRef) can therefore have repetitions.
What i would like to achieve is a crosstab (i think that's where i need to go) where:
-I have one item per line
-A department "group" with a quantity (Qty) and unit price (Valor Unitario) columns, with a total of [Valor Unitário]*[qty] by department,
like the screenshot "report". I am having problems creating this report because when i hit the crosstab wizard, i end up with a report like the "report_preview" image. I dont want to aggregate the [Qty] and [Valor Unitario] but i have to or the report wont build.
What am trying to achieve is similar to the demo "Product Sales per Period" , is there any step by step other than the video, which i cannot watch or download because flv's are blocked here?
1 Answer, 1 is accepted
0
Accepted
Massimiliano Bassili
Top achievements
Rank 1
Rank 1
answered on 27 Sep 2010, 01:01 PM
You can download the Product Sales per Period video in telerik.tv from the tabbed interface below the video where it says "Related downloads".
Cheers!
Cheers!