Pivot headers are displaying headers information

Pivot headers are displaying headers information

Posted by: ykumar23 on 13 February 2018, 10:55 pm EST

• 

  ykumar23

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 13 February 2018, 10:55 pm EST

  Hi,

  I am using pivot grid in my application.
  
  I need to display Rows, Columns and Values in the pivot grid. This is working fine when user adds more than one Rows/Values. Please refer to screenshot 1. In this picture we can clearly see “Product”, “Rows” as rows, “Downloads”, “Sales” as values and “Country” as column.

  Problem arises when we have only one row, one column, one values. When user selects one field I need to show these fields in headers as depicted in screnshot2.

• 

  ykumar23

  • Post Options:
  • Link
    Copy

  Posted 13 February 2018, 10:56 pm EST

  How can I show these header values in the [quote=“ykumar23”]
  
  Hi,

  I am using pivot grid in my application.
  
  I need to display Rows, Columns and Values in the pivot grid. This is working fine when user adds more than one Rows/Values. Please refer to screenshot 1. In this picture we can clearly see “Product”, “Rows” as rows, “Downloads”, “Sales” as values and “Country” as column.

  Problem arises when we have only one row, one column, one values. When user selects one field I need to show these fields in headers as depicted in screnshot2. How can I achieve this.

  
  
  [/quote]

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 5:04 pm EST

  Hi Kumar,

  I think what you are asking is that you want Downloads Field to appear under Japan and USA. which would be more like Group. I would suggest you to use FlexGrid instead and then group using the Downloads Column.

  This is not possible using OLAP Control because functionality of OLAP is not to Group data, it is meant to Drill Down on data and used for data mining.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 5:15 pm EST

  Hi Kumar,

  Could you please send us your license key details by sharing the information on our Support Portal Case https://supportone.componentone.com/home/casedetail/308584

  We need this information in order to prioritize case 307028 .

• 

  ykumar23

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 8:18 pm EST

  Hi Abhishek, Thank you for the quick reply.

  My questions is related to headers display.

  In screen shot -1, we set pivot panel with “Product”, “Active” as rows, “Downloads”, “Sales” as values and “Country” as column. And Grid is displaying the values according to rows, columns & values.
  
  It is also displaying “headers” (Product, Active, Downloads, Sales, Country). Hightlighted in red color is the attached screenshot.

  But when only one row, one column, one value or similar combination is set to pivot fields, grid is not displaying the headers (titles). In the below screenshot, we set “Product” for rows, “Country” for columns, “Downloads” as values. But in the grid, “Product” header is appearing, “Downloads” header is appearing. But “Country” header is not displayed instead its values Japan, USA are appearing. This might leads a confusion to the user for what fields these values are appearing. In the screenshot1 we are displaying “Country” header with its values Japan and USA which is missing in the 2nd case.
  
  Is there any solution for displaying “Country” header with its values as shown in screenshot-1 (above screenshot) ?

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 8:53 pm EST

  Sorry but currently this is not possible. If you would like I can enter a feature request for the same.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 14 February 2018, 8:59 pm EST

  Also, please send me your license on the case https://supportone.componentone.com/home/casedetail/308584.

  In case you are unable to open the case then please send me your license details at abhishek.dutta@grapecity.com