Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Anyone ever try the App Studio Format = Excel Pivot?


robert fuschetto

Recommended Posts

I was wondering how well it worked, any advise etc. Are there limitations to how the pivot is set up etc. Ex: Can I set it to do Running Total In Dept for example..Can I set up Columns/RowsPageArea,...I am not really sure what level of sophistication is available.

I see this when I set the output and I am not really even sure what to do here:

image.thumb.png.70e2e493e82775d080d5f117e589f1d5.png

Link to comment
Share on other sites

8207.28....Understand we need not only to interface it with existing content (10+ years worth) but to also start to use it for new content. We started a new portal with it but it quickly fizzled. I used to have al list...a dozen or so items....from issues with interfacing with HOLD files, to charts not sizing correctly to passing parameters, to drop down list issues...it ran the gamut....it simply would have been a step backward for us so we do not use it. I assume by now they have worked the kinks out...but we must wait.

Link to comment
Share on other sites

We use AHTML now and then but I am not aware it allows the user to move items around etc. Example:

image.png.f82485db805ad1b7e80ed335765b5a3b.png 

So beneath Division we have SubDivision, Company, Dept, Cost Center, Provider....the user may wish to look at any aggregate. In a pivot they would simply drag and drop from page area etc. I am not sure how that would work here...I'd have to put all those items on the report (across the report?) and have them filter...gets messy. Or I'd need to add drill downs which is more work...

This pivot is easier to work with..of course there maybe something I do not know about AHTML...

image.png.70fcee9a2041912fa2082d4ebb605d0b.png 

I appreciate your time!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...