set analysis

[DGAL1]

i have products sold , and i want their count using % contribution with the ID column

[LRuCelver]

I'm not quite sure I understand your question correctly. Maybe you could provide a bit more information on what data you have and what you want to calculate with it.

To determine the percentage share of a selected value in e.g. a table you can use something like:

Count(ID) / Count(total ID)

 The keyword "total" makes it so all values in the current selection will be counted, regardless of the content of e.g. a row in a table.

[RamanaKumarChintalapati · Accepted solution]

Hi @DGAL1 ,

Is this is your Requirement,

by using @LRuCelver  mentioned formula

Thanks!!!!

[DGAL1]

=Dual(WeekDay(Date-1), Mod(WeekDay(Date) - 2 + 7, 7) + 1)

kindly help me on the correct code , the above graph when i select the values for saturday are on sunday 

[mnk]

Try below expression.

=Dual(WeekDay([Date]-2), Mod(WeekDay([Date]) - 2 + 7, 7)+1 )

Let me know whether it works. If not, explain more on your requirement.

[DGAL1]

the above has failed , but when i write weekday(Date) i get the correct results however sunday starts on the graph

[jochem_zw]

Count(ID)/Count(Total ID)

format as a %