Iโm trying to find a way to group those rows by 1st two columns
(those should have only unique values) and last 3 columns should display sum of thoseโฆ
Could anyone help me to achive that?
Maybe if you show us an example of the data and how you want it to look, that might help
Sure, Iโve just updated uploaded picture in my 1st post.
Send me a screen shot of the columns you have in the SPAKOWANO table
Create a virtual Yes/No columm called [Unique] in SPAKOWANO with this formula
[_RowNumber]=MAX(Select(SPAKOWANO[_RowNumber],[Nazwa SPECYFIKACJI]=[_ThisRow].[Nazwa SPECYFIKACJI]))
Then change your start expression to
<<START: Select([SPAKOWANOs][ID],[Unique]=TRUE)>>
That should get column 1 correct
Thank you for helping me with this!
I had this:
Iโve created virtual column called [Unique] in SPAKOWANO with this formula:
[_RowNumber]=MAX(Select(SPAKOWANO[_RowNumber],[Nazwa SPECYFIKACJI]=[_ThisRow].[Nazwa SPECYFIKACJI]))
Then Iโve changed
<<Start: [Related SPAKOWANOs] >>
to
<<START: Select([Related SPAKOWANOs][ID],[Unique]=TRUE)>>
Now it looks:
Something happend, but many of those are still missing.
Send a screen shot of both the template file and the whole table for the example above with 12 rows of data. Its hard to understand which columns your trying to group by
And after changes:
Iโm trying to group by [DPL] but number values from last 3 columns (Workรณw / Palet / kg ) should consolidate.
Iโve made something like this in app view, it shows grouped DPLโs:
Automation is triggered from diffrent table โWYNIKI PRODUKCJIโ, whom SPAKOWANO is related to.
Any ideas?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |