Hi,
I want to make a layout for my pivot and user will not put rows columns filters everytime when he run the application.(I want to use Flat Data)
First i tried Deffer Update nothing happens then i wrote my SQL Table's entity names which are measures in the initial item field.
I edited measure field : Price, Sum of items, (each measure have to ',' if you want to see 2 or more measure)
I tried to make the same as measure to ROW, COLUMN, FILTER fields but it doesnt work, i also edited only 1 item without ','
And is it possible to COUNT, MAX, MIN, AVG to measures with flat data?
There is no sample for preparing a layout with flat data and lightswitch help is not enough in help docs.This is a web app.
Thank you Anatoli
Hello,
In order to load everytime some initial fields you should set the Intial values in the properties of the Infragistics Pivot Grid control. There are Columns, Rows, Filters, Measures textboxes where you could set initial values. The format that you do this is like it follows: [Date].[Calendar], [Sales Territory].[Sales Territory] . Here the comma ',' separates the items.
Currently Count, MAX, MIN are not as well as the totals are not supported. You can fill out are form for a Product Idea here: http://devcenter.infragistics.com/SignIn/SignIn.aspx?ReturnUrl=%2fProtected%2fRequestFeature.aspx
Best regards,
Anatoli
Is it possible to see TOTAL ROW or TOTAL COLOUMN?