Report Foramt

[upaliwije]

Hi Friends

I have some data relating to Sales Reps in table in Oracle. I have attached sample of it in a excel sheet.

I want to load this data into a QV data model and prepare a report as shown in the attached excel sheet. I find it difficult figure out how design the report specially with rows highlighted in Yellow color.

Kindly help with a sample QV documents

Thanks

[engishfaque]

Dear Upali,

You can do it by using Pivot Table in QlikView. Follow the following steps and make it just in few minutes.

Step 1:

i.   Add Pivot Table and set Dimension and Expression

ii. Chart Properties > Tab Presentation > Checked to Check Box "Show Partial Sums" for Total > Finish

Step 2:

Click on Tab Reports > Edit Reports > Add > Give the name to the report > OK > Edit > Drag and Drop the Pivot Table over the Report.

I hope, you'll enjoy the post.

Kind regards,

Ishfaque Ahmed

[upaliwije]

How can I add thd row9s hilighted  in yellow in the pivot table

[upaliwije]

Hi

Can some please reply my question

Thanks

[upaliwije]

Mr. Henric

Can you please see my post and give me a solution.

Thanks