Hi @1460031749,

I would create an help table in transformations that has unique rows (so it deletes the duplicate rows) then create an OLAP table accordingly.

Hi,

first of all thanks for the reply.

How can i create a help table? I thought that i need somehow create that table in pql. But i dont know how.

Another question would be where to use that pql-statement? Do i need to put it into the dimensions or the KPI section?

best regards

Andreas