Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
85
Pivot table ROW
posted

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.