Log in to AnswerLog in to Follow
UserImage.jpg
Rohit Jaswani
27Views
5Comments
Solved
Not getting data properly in Pivot
Question
Traditional Web
Application Type
Traditional Web

Hello,


I'm trying to implement the functionality of Pivot table. But not getting the expected output like it should appears in Pivot.


Please find the below screenshot that's what I'm getting but it seems not appropriate-


 I have created my settings as follows :


Not sure what I am doing wrong.  I am attaching my project file.  Any help or pointers to more information would be great.

Many Thanks!
Rohit

PivotDemo.oml
1
0
07 Jul 2022
Solution

Hi Rohit,

I have gone through your OML.

I would suggest you to remove the enclosing columns in the header Row of Data Table.

Also, You can remove the RichWidgets\List_SortColumn from the header Row. 

After doing this you would get the appropriate pivot table as you wanted. See the below Screenshot.


I hope this will helps you. Happy Low-coding :-)

Best Regards,

Rasika

0
0
07 Jul 2022

Here is your modified OML for reference.

PivotDemo.oml
1
0
07 Jul 2022

Hi Rasika,


Thank you so very much for your kind response. I followed what you mentioned above. Now, I'm getting this -


Not getting the appropriate data in pivot as you mentioned above in screenshot. Could you please let me know where exactly I'm going wrong or missing something?
I am attaching my project file. Any help or pointers to more information would be great.
Also when I'm trying to publish modified project file that you provided. I'm getting the below error-
Will wait for your kind revert.

Many Thanks!
Rohit 

Pivot.oml
0
0
08 Jul 2022

Hi Rasika,


I have got the desired output -

I was not aware before that I have to drag and drop the columns in the grey section. Somehow, that clicked in my mind and did it. Once again, Thank you so very much for your kind response and great help.


Best Regards,

Rohit

1
0
08 Jul 2022

Hi Rohit,

Sorry for the late reply. I have read your previous comment but didn't get time to respond you back. and my environment is also down for maintenance. 

But, I am happy to helped you on this.

Cheers

1
0
08 Jul 2022
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.